Re: scram-sha-256 authentication

2021-01-10 Thread Sébastien Hoorens
Hi Jonathan and Michael, Thank you for the quick reply, I will ask my questions in community support areas from now on, my apologies. Your answers were very helpful. I will use psql’s \password command to set the users’ passwords for me instead of trying to generate and set the encoded passwor

Re: scram-sha-256 authentication

2021-01-05 Thread Michael Paquier
On Tue, Jan 05, 2021 at 09:12:58AM -0500, Jonathan S. Katz wrote: > I am not sure what your end goal is, but there are a few ways to create > the hashed SCRAM verifier: > > - Using the \password flag in "psql" > - Using one of the connection drivers that interfaces with libpq's > PQencryptPassword

Re: scram-sha-256 authentication

2021-01-05 Thread Jonathan S. Katz
On 1/4/21 12:04 PM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/11/auth-password.html > Description: > > How do you encode a plain password to the corresponding SCRAM-SHA-256 > encryption? Using online

scram-sha-256 authentication

2021-01-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/auth-password.html Description: How do you encode a plain password to the corresponding SCRAM-SHA-256 encryption? Using online tools I obtain a result in a different format the in e.g. the