Postgres Pro
Downloads
Home   >   mailing lists

Re: encrypt psql password in unix script - Mailing list pgsql-sql

From Steve Midgley
Subject Re: encrypt psql password in unix script
Date
Msg-id CAJexoSKSz75caNVyYHdONYsjKYHCAN_ONknO6X7fOr8CVQfgNA@mail.gmail.com
Whole thread Raw
In response to encrypt psql password in unix script  (Suresh Raja <suresh.rajaabc@gmail.com>)
Responses Re: [GENERAL] encrypt psql password in unix script  (Xavier Stevens <xavier@simple.com>)
List pgsql-sql
Tree view
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.rajaabc@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

pgsql-sql by date:

Previous
From: Suresh Raja
Date:
Subject: encrypt psql password in unix script
Next
From: Xavier Stevens
Date:
Subject: Re: [GENERAL] encrypt psql password in unix script