md5 password valid and invalid after upgrading

From: Kyle MacMillan <macattackftw(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: md5 password valid and invalid after upgrading
Date: 2023-09-26 23:14:06
Message-ID: CACW=iPvfCQwrTwKJ+7yA5D66VTq5GxBvX591jxBBTAa1nvaRDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

Issue:
Unable to log into database with md5 password, only after upgrading remote
system's psql version.

Error:
psql: error: connection to server at... failed: fe_sendauth: error sending
password authentication

Steps:

1. Setup Postgres 11.17 with an MD5 password
2. Access the DB from a remote system that only has psql 9.6
3. Upgrade DB to Postgres15.x
4. Log into database using psql 9.6 and the original password
5. Observe no issues
6. Upgrade psql on remote system to 14.x
7. Attempt to log in and see an error

The documentation regarding Postgres 14 does not specify the old password
will not work. It specifies the default was changed and that *new*
passwords will be stored as SHA256. I am not using boolean-like values for
my current password.

psql14 does not appear to recognize that it needs to use md5 but psql9
doesn't know any better, so it works.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dean Rasheed 2023-09-27 07:29:27 Re: BUG #18103: bugs of concurrent merge into when use different join plan
Previous Message Bruce Momjian 2023-09-26 16:09:01 Re: BUG #18124: PG16 release note document bug in "Add build option to allow testing of small WAL segment sizes"