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 6 Jan 2021, at 02:57, Michael Paquier <mich...@paquier.xyz> wrote: > > 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
