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