Re: Calling pg_dump from another application in safe mode

From: Richard Huxton <dev(at)archonet(dot)com>
To: Albert <alberto(dot)molteni(at)libero(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Calling pg_dump from another application in safe mode
Date: 2006-11-29 09:29:36
Message-ID: 456D5300.4010202@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message vivek 2006-11-29 10:43:05 Dynamic views
Previous Message Albert 2006-11-29 09:05:46 Calling pg_dump from another application in safe mode