How can i dump a password-protected database using perl (DBI or pg) or C (using libpq)? I can't pass the password to pg_dump utility (I was trying to pass it via tty also) when running system() from perl.
Isn't example below something like what you are trying to do:====8<==== #include <stdio.h> #include <stdlib.h> int main(void) { system("export PGDATABASE=\"test\"; export PGPASSWORD=\"test\"; export PGUSER=\"test\"; psql"); exit(0); } ====8<==== ? Here psql should connect to db 'test' as user 'test', password 'test'. Check if it works with pg_dump.
This doesn't work on my 7.2.1 installation :/ I need to run pg_dump actually. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
