From: | Steve Midgley <science(at)misuse(dot)org> |
---|---|
To: | Suresh Raja <suresh(dot)rajaabc(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: encrypt psql password in unix script |
Date: | 2015-07-08 19:01:02 |
Message-ID: | CAJexoSKSz75caNVyYHdONYsjKYHCAN_ONknO6X7fOr8CVQfgNA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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(dot)rajaabc(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Vick Khera | 2015-07-08 19:06:51 | Re: encrypt psql password in unix script |
Previous Message | John R Pierce | 2015-07-08 18:46:23 | Re: encrypt psql password in unix script |
From | Date | Subject | |
---|---|---|---|
Next Message | Vick Khera | 2015-07-08 19:06:51 | Re: encrypt psql password in unix script |
Previous Message | John R Pierce | 2015-07-08 18:46:23 | Re: encrypt psql password in unix script |