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]