| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | rariasamaya(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #17719: scram-sha-256 is not working on PostgreSQL 11.18 |
| Date: | 2022-12-14 02:56:15 |
| Message-ID: | Y5k7T00man/GtMvj@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | okijhhyu | 2022-12-14 07:20:21 | Sort bug |
| Previous Message | PG Bug reporting form | 2022-12-13 21:02:56 | BUG #17719: scram-sha-256 is not working on PostgreSQL 11.18 |