Re: [GENERAL] about "pg_dump " without pompt password

2004-10-02 Thread David Garamond
Tom Lane wrote: At least in Linux, mysql replaces the password in the command line argument with "" so you can't see them via "ps" nor via peeking into /proc//cmdline. There is a short period where the password is visible though. Are there any other risks? Or is the reason for not doing

Re: [GENERAL] about "pg_dump " without pompt password

2004-10-02 Thread David Garamond
Tom Lane wrote: 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 pa

Re: [GENERAL] about "pg_dump " without pompt password

2004-10-02 Thread Tom Lane
David Garamond <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >>> 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 manua

Re: [GENERAL] about "pg_dump " without pompt password

2004-09-30 Thread Tom Lane
Ying Lu <[EMAIL PROTECTED]> writes: > 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.