Postgres Pro
Downloads
Home   >   mailing lists

SV: Problem with ssl and psql in Postgresql 13 - Mailing list pgsql-general

From Gustavsson Mikael
Subject SV: Problem with ssl and psql in Postgresql 13
Date
Msg-id 06191eae74d045e192a786a84a73ba53@smhi.se
Whole thread Raw
In response to Re: Problem with ssl and psql in Postgresql 13  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Responses Re: SV: Problem with ssl and psql in Postgresql 13  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view


Hi,


SSL is on. 


grep ssl /etc/postgresql/13/postgresql.conf  
ssl = 'on'
ssl_cert_file = '/etc/pki/private/xxx_incl_key.pem'
ssl_key_file = '/etc/pki/private/xxx.key'


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

pgsql-general by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Problem with ssl and psql in Postgresql 13
Next
From: Tom Lane
Date:
Subject: Re: SV: Problem with ssl and psql in Postgresql 13