While fixing the gui for pg_dump and pg_restore, I painfully noticed there's no option for the password.
After some tests, I found that using the PGPASSWORD environment variable will do the job. I'm a bit irritated that it's marked "deprecated" in the docs, the .pgpass solution isn't a good one for tool managed passwords.
Hopefully PGPASSWORD won't vanish until there's another solution to execute pgsql client tools...

I didn't notice it was deprecated either - it's the only way that phpPgAdmin can integrate with pg_dump...


Chris


---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Reply via email to