Re: specifying a password on the cmd line for db connect

[Greg Smith <greg@xxxxxxxxxxxxxxx>]

Gauthier, Dave wrote:

Hi:

 

Is there a way to require and specify a password at the cmd line for a connect?

You don't want to do that because any user on the system can see the command, and thus the password.  You want to use a .pgpass file instead:

http://www.postgresql.org/docs/8.4/interactive/libpq-pgpass.html

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@xxxxxxxxxxxxxxx  www.2ndQuadrant.com