Re: scram-sha-256 encrypted password in pgpass - Mailing list pgsql-admin

From David G. Johnston
Subject Re: scram-sha-256 encrypted password in pgpass
Date
Msg-id CAKFQuwYHDX1FU-rBzv9GXR_9P6dJpryFfUUgZ1bG4xT_8ZqiDQ@mail.gmail.com
Whole thread Raw
In response to Re: scram-sha-256 encrypted password in pgpass  (Pavan Kumar <pavan.dba27@gmail.com>)
List pgsql-admin
On Mon, Jun 22, 2020 at 3:32 PM Pavan Kumar <pavan.dba27@gmail.com> wrote:
Adrian, David,

Thank you so much for the quick response.  

What would be the point of storing the encrypted password instead of the plaintext one? 
As per our organization security policies, we can 't keep any  passwords in plain text format. 
I am working on postgres + pgbouncer setup, tested pgbouncer 1.14 where we have support to use encrypted password in userlist,txt file. I am surprised why  pgpass is not supporting encrypted passwords.


Just use a long string of random letters, numbers, and symbols and say its encrypted...

David J.

pgsql-admin by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: scram-sha-256 encrypted password in pgpass
Next
From: Stephen Frost
Date:
Subject: Re: scram-sha-256 encrypted password in pgpass