Hello, I upgraded from postgresql 9.5 to 14.8. After the upgrade users were not able to connect due to password hash.
The password encryption was on scram-sha-256. The password hash was on md5. in the pg_hba.conf file the authentication method was md5. I do not know why users could not connect because as per postgresql documentation, that should work. I have previously done a similar upgrade and did not face similar issues. Kind regards Johnathan Tiamoh
