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