Re: No psql md5 auth, psql 14.1 to PG 11 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: No psql md5 auth, psql 14.1 to PG 11
Date
Msg-id f5251a58-9185-0384-d30a-1426dc7dfc85@aklaver.com
Whole thread Raw
In response to No psql md5 auth, psql 14.1 to PG 11  ("Pete O'Such" <posuch@gmail.com>)
Responses Re: No psql md5 auth, psql 14.1 to PG 11  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.klaver@aklaver.com



pgsql-general by date:

Previous
From: "Pete O'Such"
Date:
Subject: No psql md5 auth, psql 14.1 to PG 11
Next
From: Tom Lane
Date:
Subject: Re: No psql md5 auth, psql 14.1 to PG 11