Dixit Tim Frank <tfrank(at)registrar(dot)uoguelph(dot)ca> (le Tue, 20 Mar 2001 00:14:11 GMT) :
» Have your shell script do
»
» export PGUSER=username
» export PGPASSWORD=password
»
» before you run pg_dumpall in the same script. The user/pass would most
» likely have to be a superuser to have access to all databases (this is
» also not guaranteed depending on your pg_hba.conf). Make the script
» read/execute by root but not by anyone else and it will help a tiny bit
» with security.
Using something like "ps -e" shows the environment variables so it is
as unsecure as giving the password on the commande line.
Thierry