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