Home > mailing lists

PG_DUMP question - Mailing list pgsql-general

From	Alex
Subject	PG_DUMP question
Date	December 1, 2003 23:32:30
Msg-id	3FCBDD6F.2040801@meerkatsoft.com Whole thread Raw
Responses	Re: PG_DUMP question (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List	pgsql-general

Tree view

Hi,
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

I tried
PGUSER=userid PGPASSWD=passwd pg_dump -Fc -f dump.db mydb;

Thanks
Alex

pgsql-general by date:

From: "Jay O'Connor"
Date: 01 December 2003, 23:19:13
Subject: Re: Triggers, Stored Procedures, PHP. was: Re: PostgreSQL

From: "Rick Gigger"
Date: 01 December 2003, 23:45:34
Subject: Re: PostgreSQL Advocacy, Thoughts and Comments

PG_DUMP question - Mailing list pgsql-general

Previous

Next