Re: scram-sha-256 encrypted password in pgpass

2020-06-22 Thread Adrian Klaver
On 6/22/20 3:54 PM, Stephen Frost wrote: Greetings, * Pavan Kumar (pavan.db...@gmail.com) wrote: 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. Then you nee

Re: scram-sha-256 encrypted password in pgpass

2020-06-22 Thread Ravi Krishna
> > But if you want to log in with encrypted password and someone can grab > it from the file not sure what the difference is from grabbing the plain > text one if they both end up logging the user in? Exactly. saved me the trouble of typing this.

Re: scram-sha-256 encrypted password in pgpass

2020-06-22 Thread Stephen Frost
Greetings, * Pavan Kumar (pavan.db...@gmail.com) wrote: > > 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. Then you need to *actually* encrypt the passwo

Re: scram-sha-256 encrypted password in pgpass

2020-06-22 Thread David G. Johnston
On Mon, Jun 22, 2020 at 3:32 PM Pavan Kumar 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 tex

Re: scram-sha-256 encrypted password in pgpass

2020-06-22 Thread Adrian Klaver
On 6/22/20 3:32 PM, Pavan Kumar 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. But if you w

Re: scram-sha-256 encrypted password in pgpass

2020-06-22 Thread Pavan Kumar
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 pgboun

Re: scram-sha-256 encrypted password in pgpass

2020-06-22 Thread David G. Johnston
Please don't cross-post. On Mon, Jun 22, 2020 at 1:35 PM Pavan Kumar wrote: > scram-sha-256 encrypted passwords are supported in .pgpass file ? If yes > kindly provide us an example. > > I am using below format and it is not working for me > > *pglnx1*:*5432*:pgbouncer:*pgadmin*:"SCRAM-SHA-256$4

Re: scram-sha-256 encrypted password in pgpass

2020-06-22 Thread Adrian Klaver
On 6/22/20 1:34 PM, Pavan Kumar wrote: Hello expertes, scram-sha-256 encrypted passwords are supported in .pgpass file ? If yes kindly provide us an example. I am using below format and it is not working for me /|pglnx1|/:/|5432|/:pgbouncer:/|pgadmin|/:"SCRAM-SHA-256$4096:6IDsjfedwsdpymp0Za7

scram-sha-256 encrypted password in pgpass

2020-06-22 Thread Pavan Kumar
Hello expertes, scram-sha-256 encrypted passwords are supported in .pgpass file ? If yes kindly provide us an example. I am using below format and it is not working for me *pglnx1*:*5432*:pgbouncer:*pgadmin*:"SCRAM-SHA-256$4096:6IDsjfedwsdpymp0Za7jaMew==$rzSoYL4ZYsW1WJAj7Lt3JtNLNR73AVY7sfsauikwe