Thread: Calling pg_dump from another application in safe mode

Hi, I'm wondering if there is a method to call pg_dump from an external
application without changing the security level in pg_hba.conf from
trust to md5. I'd like to pass my password not in clear but using a
secure cryptographic method like md5.

Any suggestion? Thanks!

Albert wrote:
> Hi, I'm wondering if there is a method to call pg_dump from an external
> application without changing the security level in pg_hba.conf from
> trust to md5. I'd like to pass my password not in clear but using a
> secure cryptographic method like md5.

You want the ".pgpass" file - it's mentioned in the libpq section of the
docs.
http://www.postgresql.org/docs/8.1/static/libpq-pgpass.html

--
   Richard Huxton
   Archonet Ltd