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.
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" |