Calling pg_dump from another application in safe mode

Started by Albertover 19 years ago2 messagesgeneral
Jump to latest
#1Albert
alberto.molteni@libero.it

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!

#2Richard Huxton
dev@archonet.com
In reply to: Albert (#1)
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