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 <scie...@misuse.org> 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) > > If you can't do that, the only other method I've used is to setup Postgres > with Ansible, and store the Pg passwords in an ansible vault, which is > encrypted. Ansible asks for the decrypt key when it runs. > > Steve > > > On Wed, Jul 8, 2015 at 11:34 AM, Suresh Raja <suresh.raja...@gmail.com> > wrote: > >> Hi: >> >> 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. >> >> Thanks, >> -SR >> > >
