Re: Pass password in scripts? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Pass password in scripts?
Date
Msg-id 9996.1171503301@sss.pgh.pa.us
Whole thread Raw
In response to Pass password in scripts?  ("Neil Aggarwal" <neil@JAMMConsulting.com>)
Responses Re: Pass password in scripts?  ("Neil Aggarwal" <neil@JAMMConsulting.com>)
List pgsql-novice
"Neil Aggarwal" <neil@JAMMConsulting.com> writes:
> With mysql, I can pass the password to the database in
> the command line call to the terminal client.

Really?  That's an enormous security hole, because anyone running "ps"
on the system can see your password.

> Is there a way to do that with psql?

Consider using a ~/.pgpass file instead.  Much safer.

            regards, tom lane

pgsql-novice by date:

Previous
From: Jan Danielsson
Date:
Subject: Re: Pass password in scripts?
Next
From: "Neil Aggarwal"
Date:
Subject: Re: Pass password in scripts?