Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: SV: SV: Problem with ssl and psql in Postgresql 13
Date
Msg-id 89909.1608222331@sss.pgh.pa.us
Whole thread Raw
In response to SV: SV: Problem with ssl and psql in Postgresql 13  (Gustavsson Mikael <mikael.gustavsson@smhi.se>)
Responses SV: SV: SV: Problem with ssl and psql in Postgresql 13  (Gustavsson Mikael <mikael.gustavsson@smhi.se>)
List pgsql-general
Tree view 
Gustavsson Mikael <mikael.gustavsson@smhi.se> writes:
> $ /usr/pgsql-13/bin/psql "dbname=postgres user=kalle host=server sslmode=require"
> psql: error: FATAL:  no pg_hba.conf entry for host "nn.nnn.n.nnn", user "kalle", database "postgres", SSL off
> FATAL:  no pg_hba.conf entry for host "nn.nnn.n.nnn", user "kalle", database "postgres", SSL off

It'd be useful to verify that that version of psql+libpq is actually
built with ssl support.  Try

ldd /usr/pgsql-13/bin/psql

and then repeat "ldd" on whichever libpq.so is mentioned in the output.

            regards, tom lane

pgsql-general by date:

Previous
From: Gustavsson Mikael
Date:
Subject: SV: SV: Problem with ssl and psql in Postgresql 13
Next
From: Gustavsson Mikael
Date:
Subject: SV: SV: SV: Problem with ssl and psql in Postgresql 13