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