Re: Calling pg_dump from another application in safe mode - Mailing list pgsql-general

From Richard Huxton
Subject Re: Calling pg_dump from another application in safe mode
Date
Msg-id 456D5300.4010202@archonet.com
Whole thread Raw
In response to Calling pg_dump from another application in safe mode  ("Albert" <alberto.molteni@libero.it>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Albert"
Date:
Subject: Calling pg_dump from another application in safe mode
Next
From: "surabhi.ahuja"
Date:
Subject: sudden drop in delete performance