PG_DUMP question

On Tue, Dec 02, 2003 at 09:31:43AM +0900, Alex wrote:
[color=blue]
> 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[/color]

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)

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Thanks,
but I am looking for a way to pass the password to the command rather
than using another config or password file.
I store my config infos in an xml file.
I thought I could set the environment var as suggested on some sites but
it does not seem to be working.
Alex

Alvaro Herrera wrote:
[color=blue]
>On Tue, Dec 02, 2003 at 09:31:43AM +0900, Alex wrote:
>
>
>[color=green]
>>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
>>
>>[/color]
>
>Use the ~/.pgpass file. It will work for any libpq program, not just
>pg_dump.
>
>
>[/color]



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

On Tue, Dec 02, 2003 at 05:31:45PM +0900, Alex wrote:
[color=blue]
> but I am looking for a way to pass the password to the command rather
> than using another config or password file.
> I store my config infos in an xml file.
> I thought I could set the environment var as suggested on some sites but
> it does not seem to be working.[/color]

It should work. Note though that it is called PGPASSWORD, not PGPASSWD
as your example was showing. Be sure to export it.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Las cosas son buenas o malas segun las hace nuestra opinión" (Lisias)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to Join Bytes! so that your
message can get through to the mailing list cleanly