Re: [GENERAL] encrypt psql password in unix script

2015-07-08 Thread Vick Khera
On Wed, Jul 8, 2015 at 2:46 PM, John R Pierce wrote: > but what security does that gain you?if someone gets your > encrypted/hashed password, he can still log on. the pgpass file has to be > permissions 700, so only YOU (and root) can read it. > Exactly this. If you want a script to authen

Re: [GENERAL] encrypt psql password in unix script

2015-07-08 Thread John R Pierce
On 7/8/2015 11:34 AM, Suresh Raja wrote: I cannot use .pgpass as the password stored here is not encrypted. can i use a encrypted password from unix shell script. has anybody ran into same situation. Wht options do i have. I believe anywhere you enter a password in postgres, it can be the ha