Clarification, its the same postgresql13 server. I just connect with different psql-clients.
KR
Från: Kyotaro Horiguchi <horikyota.ntt@gmail.com> Skickat: den 17 december 2020 09:29:38 Till: Gustavsson Mikael Kopia: pgsql-general@postgresql.org; Svensson Peter Ämne: Re: Problem with ssl and psql in Postgresql 13
Hi.
At Thu, 17 Dec 2020 07:21:08 +0000, Gustavsson Mikael <mikael.gustavsson@smhi.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