PG_DUMP question - Mailing list pgsql-general

From Alex
Subject PG_DUMP question
Date
Msg-id 3FCBDD6F.2040801@meerkatsoft.com
Whole thread Raw
Responses Re: PG_DUMP question
List pgsql-general
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:

Previous
From: "Jay O'Connor"
Date:
Subject: Re: Triggers, Stored Procedures, PHP. was: Re: PostgreSQL
Next
From: "Rick Gigger"
Date:
Subject: Re: PostgreSQL Advocacy, Thoughts and Comments