| From: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
|---|---|
| To: | mikael(dot)gustavsson(at)smhi(dot)se |
| Cc: | pgsql-general(at)postgresql(dot)org, peter(dot)svensson(at)smhi(dot)se |
| Subject: | Re: Problem with ssl and psql in Postgresql 13 |
| Date: | 2020-12-17 08:29:38 |
| Message-ID: | 20201217.172938.170511532557914014.horikyota.ntt@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi.
At Thu, 17 Dec 2020 07:21:08 +0000, Gustavsson Mikael <mikael(dot)gustavsson(at)smhi(dot)se> wrote in
> But not from psql 13:
> $ /usr/pgsql-13/bin/psql -d postgres -Ukalle -hserver -W
> Password:
> psql: error: FATAL: no pg_hba.conf entry for host "nnn.nn.n.nnn", user "kalle", database "postgres", SSL off
> FATAL: no pg_hba.conf entry for host "nnn.nn.n.nnn", user "kalle", database "postgres", SSL off
It looks like the option "ssl" (in postgresql.conf) is turned off on
the v13 server. You will find lines like the following in the server
log in that case.
LOG: hostssl record cannot match because SSL is disabled
HINT: Set ssl = on in postgresql.conf.
regards.
--
Kyotaro Horiguchi
NTT Open Source Software Center
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gustavsson Mikael | 2020-12-17 09:11:13 | SV: Problem with ssl and psql in Postgresql 13 |
| Previous Message | Gustavsson Mikael | 2020-12-17 07:43:26 | SV: postgres auditing truncates and deletes on tables |