[ovirt-users] Ovirt Engine Pgsql password

[Alon Bar-Lev]

Hi,

Credentials are at:

/etc/ovirt-engine/engine.conf.d/10-setup-database.conf

You can use the following script as an example:
---
ovirt-engine-psql.sh
---
#!/bin/sh
. /usr/share/ovirt-engine/bin/engine-prolog.sh
PGPASS="$(mktemp)"
cleanup() {
        rm -f "${PGPASS}"
}
trap cleanup 0
PASSWORD="$(sed 's;\(["\$]\);\\\1;g' << __EOF__
${ENGINE_DB_PASSWORD}
__EOF__
)"
cat > "${PGPASS}" << __EOF__
${ENGINE_DB_HOST}:${ENGINE_DB_PORT}:${ENGINE_DB_DATABASE}:${ENGINE_DB_USER}:${PASSWORD}
__EOF__
PGPASSFILE="${PGPASS}"  psql -h "${ENGINE_DB_HOST}" -p "${ENGINE_DB_PORT}" -U "${ENGINE_DB_USER}" -d "${ENGINE_DB_DATABASE}" "$@"
---

Alon

----- Original Message -----
> From: "Punit Dambiwal" <hypunit at gmail.com>
> To: users at ovirt.org
> Sent: Wednesday, August 27, 2014 7:34:53 AM
> Subject: [ovirt-users] Ovirt Engine Pgsql password
> 
> Hi All,
> 
> I want to know how i can fetch the password of the pgsql...and how i can
> connect it thorugh remote pgsql client ??
> 
> Thanks,
> punit
> 
> _______________________________________________
> Users mailing list
> Users at ovirt.org
> http://lists.ovirt.org/mailman/listinfo/users
>