Calling pg_dump from another application in safe mode
Started by Albertover 19 years ago2 messagesgeneral
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!
Re: Calling pg_dump from another application in safe mode
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