Postgres Pro
Downloads
Home   >   mailing lists

Re: specifying a password on the cmd line for db connect - Mailing list pgsql-general

From Greg Smith
Subject Re: specifying a password on the cmd line for db connect
Date
Msg-id 4B01DA93.3090403@2ndquadrant.com
Whole thread Raw
In response to specifying a password on the cmd line for db connect  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
Tree view
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@2ndQuadrant.com  www.2ndQuadrant.com

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: specifying a password on the cmd line for db connect
Next
From: Raymond O'Donnell
Date:
Subject: Re: specifying a password on the cmd line for db connect