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