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