From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Pete O'Such <posuch(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: No psql md5 auth, psql 14.1 to PG 11 |
Date: | 2022-04-18 20:30:17 |
Message-ID: | f5251a58-9185-0384-d30a-1426dc7dfc85@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 4/18/22 13:12, Pete O'Such wrote:
> I'm unable to authenticate with psql to a PG 11 database on server A
> from server B which has PG 14.1 installed. So it's psql 14.1 not
> authenticating to PG 11. Other clients can and do authenticate to the
> PG 11 database, it only seems to fail with the psql 14.1 client.
>
> The PG 11 server uses md5. So is the PG 14.1, but I didn't expect that
> to matter for a straight psql connection plus interactive password entry.
My first thought was that is was a md5/scram-sha-256 issue but I'm not
sure how as both versions support both password types.
So:
1) How where the Postgres instances installed on both machines?
2) What is the exact psql command you are using?
3) What is the complete error message?
> Thanks,
> Pete O'Such
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-04-18 21:08:14 | Re: No psql md5 auth, psql 14.1 to PG 11 |
Previous Message | Pete O'Such | 2022-04-18 20:12:47 | No psql md5 auth, psql 14.1 to PG 11 |