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