Re: BUG #17719: scram-sha-256 is not working on PostgreSQL 11.18 - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #17719: scram-sha-256 is not working on PostgreSQL 11.18
Date
Msg-id Y5k7T00man/GtMvj@paquier.xyz
Whole thread Raw
In response to BUG #17719: scram-sha-256 is not working on PostgreSQL 11.18  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Tue, Dec 13, 2022 at 09:02:56PM +0000, PG Bug reporting form wrote:
> In both machines the behaviour was the same. scram-sha-256 is not working on
> PostgreSQL 11.18 , despite PostgreSQL claims it works since version 10.
> scram-sha-256 DOES work on PostgreSQL version 14.6, which I tested in both
> machines.

Are you sure that you have a SCRAM password for this user in pg_authid
when it comes to 11.18?  The default value of password_encryption (as
in postgresql.conf) has been changed from "md5" to "scram-sha-256" in
14 so it works out-of-the-box.  When using server versions older than
14 that you need the extra step to set this parameter first, before
changing the password of a user.
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17719: scram-sha-256 is not working on PostgreSQL 11.18
Next
From: okijhhyu
Date:
Subject: Sort bug