Dixit Tim Frank <[EMAIL PROTECTED]> (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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl