Re: libpq15 with postgres server16 and scram-sha-256

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: MM <finjulhich(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: libpq15 with postgres server16 and scram-sha-256
Date: 2024-09-04 11:24:25
Message-ID: 981dd499db1c6464b4e5d6461a6519cf4029ba7d.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message yudhi s 2024-09-04 12:49:47 question on audit columns
Previous Message MM 2024-09-04 10:54:12 libpq15 with postgres server16 and scram-sha-256