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




---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to