From: | "Neil Aggarwal" <neil(at)JAMMConsulting(dot)com> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Pass password in scripts? |
Date: | 2007-02-15 01:55:24 |
Message-ID: | 000701c750a4$5c702320$0501a8c0@neilhp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Tom:
There is no ~ directory for the db user.
The scripts run as root.
Should I put it in the home directory for root?
Thanks,
Neil
--
Neil Aggarwal, (214)986-3533, www.JAMMConsulting.com
FREE! Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wednesday, February 14, 2007 7:35 PM
To: Neil Aggarwal
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Pass password in scripts?
"Neil Aggarwal" <neil(at)JAMMConsulting(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Aggarwal | 2007-02-15 01:59:20 | Re: Pass password in scripts? |
Previous Message | Tom Lane | 2007-02-15 01:35:01 | Re: Pass password in scripts? |