On Wed, Jul 9, 2025 at 6:57 AM Alpaslan AKDAĞ <alpaslanak...@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.
