Re: PG_DUMP question - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: PG_DUMP question
Date
Msg-id 20031202011733.GB18577@dcc.uchile.cl
Whole thread Raw
In response to PG_DUMP question  (Alex <alex@meerkatsoft.com>)
Responses Re: PG_DUMP question
List pgsql-general
On Tue, Dec 02, 2003 at 09:31:43AM +0900, Alex wrote:

> is ther a way to pass a password to the pg_dump command to avoid being
> prompted for it.
> I want to execute the dump from a perl or shell script and dont want to
> open accees for the user in the pg_hba.conf

Use the ~/.pgpass file.  It will work for any libpq program, not just
pg_dump.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"I call it GNU/Linux. Except the GNU/ is silent." (Ben Reiter)

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Triggers, Stored Procedures, PHP. was: Re: PostgreSQL
Next
From: merlyn@stonehenge.com (Randal L. Schwartz)
Date:
Subject: Re: Triggers, Stored Procedures, PHP. was: Re: PostgreSQL