Downloads
Home   >   mailing lists

Re: Password Encryption and Connection Issues - Mailing list pgsql-general

From David G. Johnston
Subject Re: Password Encryption and Connection Issues
Date
Msg-id CAKFQuwbtK4Pc4PZPOYe7spXZsjou7Q-md4n5mVUJv0HzKcd9KQ@mail.gmail.com
Whole thread Raw
In response to Password Encryption and Connection Issues  (Alpaslan AKDAĞ <alpaslanakdag@gmail.com>)
List pgsql-general
Tree view
On Wed, Jul 9, 2025 at 6:57 AM Alpaslan AKDAĞ <alpaslanakdag@gmail.com> wrote:
  1. In such a case, what would be the recommended approach or best practice to follow during upgrades in order to avoid this kind of issue?
This is all described quite clearly in the documentation, including the upgrade procedure in the final paragraph.

https://www.postgresql.org/docs/current/auth-password.html

Given that pg_hba.conf still uses md5 I'm a bit confused regarding the claim of some people being unable to authenticate; but you've provided insufficient data to diagnose.  In any case, hopefully you can just change all passwords to use scram and move on.

David J.

pgsql-general by date:

Previous
From: Jordan Adams
Date:
Subject: PostgresSQL Setup error
Next
From: Greg Sabino Mullane
Date:
Subject: Re: Password Encryption and Connection Issues