Need Help On Upgrade

From: Johnathan Tiamoh <johnathantiamoh(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Need Help On Upgrade
Date: 2023-07-10 18:15:55
Message-ID: CACoPQdb-goLOnE5Pjna=23872tBVONZ=xNqKD8ynv=44FRcSFA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DAVID ROTH 2023-07-10 18:20:30 Trigger Function question
Previous Message Nathan Bossart 2023-07-10 17:45:31 Re: Is anyone using db_user_namespace?