Postgres Pro
Downloads
Home   >   mailing lists

Re: libpq15 with postgres server16 and scram-sha-256 - Mailing list pgsql-general

From Laurenz Albe
Subject Re: libpq15 with postgres server16 and scram-sha-256
Date
Msg-id 981dd499db1c6464b4e5d6461a6519cf4029ba7d.camel@cybertec.at
Whole thread Raw
In response to libpq15 with postgres server16 and scram-sha-256  (MM <finjulhich@gmail.com>)
List pgsql-general
Tree view 
On Wed, 2024-09-04 at 11:54 +0100, MM wrote:
> is it possible to connect with PGConnectdb version 15 to a server that has in METHOD in pg_hba.conf   "scram-sha-256"
> or do I need version libpq 16 ?

You can use "scram-sha-256" authentication from v10 on.

Note that it only works if the database password is a scram-sha-256 hash, not an MD5 hash.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: MM
Date:
Subject: libpq15 with postgres server16 and scram-sha-256
Next
From: yudhi s
Date:
Subject: question on audit columns