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 password myself. I tried out this solution with success.
Best regards,
Sébastien
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
PQencryptPasswordConn function[2]
- Some driver's handle the password hashing independently
Another thing to be careful about is the value of password_encryption
in postgresql.conf. The default has been changed to scram-sha-256 in
c7eab0e, meaning that this change will be available in Postgres 14~.
But if your environment is using the default configuration of 11, that
may be set to "md5".
--
Michael