Re: [GENERAL] [SQL] encrypt psql password in unix script

2015-07-08 Thread John R Pierce
On 7/8/2015 12:01 PM, Steve Midgley wrote: My suggestion is to put it in an environment variable and set that variable from a shell startup script that is secured with permissions. (http://www.postgresql.org/docs/9.4/static/libpq-envars.html) that just moves the problem, now the plaintext pa

Re: [GENERAL] [SQL] encrypt psql password in unix script

2015-07-08 Thread Xavier Stevens
I use envcrypt for things like this locally. Just encrypt the file with your own PGP key. https://github.com/whilp/envcrypt On Wed, Jul 8, 2015 at 12:01 PM, Steve Midgley wrote: > My suggestion is to put it in an environment variable and set that > variable from a shell startup script that is s

Re: [GENERAL] [SQL] encrypt psql password in unix script

2015-07-08 Thread Steve Midgley
My suggestion is to put it in an environment variable and set that variable from a shell startup script that is secured with permissions. ( http://www.postgresql.org/docs/9.4/static/libpq-envars.html) If you can't do that, the only other method I've used is to setup Postgres with Ansible, and stor