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@xxxxxxxxxxx
