PG_DUMP question

From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PG_DUMP question
Date: 2003-12-02 00:31:43
Message-ID: 3FCBDD6F.2040801@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2003-12-02 00:32:47 Re: Equivalent to DBMS_JOB
Previous Message Jay O'Connor 2003-12-02 00:18:17 Re: Triggers, Stored Procedures, PHP. was: Re: PostgreSQL