Is it possible that we setup the password in the pg_dump command line
You might as well put it on a billboard --- anything in the command line can be seen by anyone who runs "ps".
If you don't want to supply it manually, put it in ~/.pgpass.
At least in Linux, mysql replaces the password in the command line argument with "xxxxxxxx" so you can't see them via "ps" nor via peeking into /proc/<PID>/cmdline.
There is a short period where the password is visible though.
Are there any other risks? Or is the reason for not doing this is because not all OS'es supports replacing the command line information?
-- dave
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
