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

[Greg Smith]

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
g...@2ndquadrant.com  www.2ndQuadrant.com