pg13 psql can't connect pg instance with ssl enabled after upgrading

From: jian xu <jamesxu(at)outlook(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pg13 psql can't connect pg instance with ssl enabled after upgrading
Date: 2021-02-12 21:16:23
Message-ID: BL0PR02MB456168A5C9909C71C578CFFDA18B9@BL0PR02MB4561.namprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,
I got a strange issue with ssl connection after upgrading an instance from pg11 to pg13.
the instance didn't have ssl enabled, we upgraded it to pg13, then enabled ssl, however when we try to login with pg13 psql 13, psql always try ssl=off to login
public_postgresql_13_1/bin/psql "sslmode=require host=xxxxxx dbname=postgres"
psql: error: FATAL: no pg_hba.conf entry for host "xxxxx", user "xxxx", database "postgres", SSL off

however, if we use pg11 psql, it worked with the upgraded instance
public_postgresql_11_8/bin/psql "sslmode=require host=xxxxxx dbname=postgres"
psql (11.8, server 13.1)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)

but pg13 psql can work with other pg13 instance with ssl enabled(new installation), only the upgraded instance doesn't work

any thoughts?

thanks,

James

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2021-02-12 21:50:23 Re: pg13 psql can't connect pg instance with ssl enabled after upgrading
Previous Message Keith Fiske 2021-02-12 15:30:21 Re: index bloat estimation