| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Gustavsson Mikael <mikael(dot)gustavsson(at)smhi(dot)se> |
| Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Svensson Peter <peter(dot)svensson(at)smhi(dot)se> |
| Subject: | Re: SV: SV: Problem with ssl and psql in Postgresql 13 |
| Date: | 2020-12-17 16:25:31 |
| Message-ID: | 89909.1608222331@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Gustavsson Mikael <mikael(dot)gustavsson(at)smhi(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gustavsson Mikael | 2020-12-17 16:33:13 | SV: SV: SV: Problem with ssl and psql in Postgresql 13 |
| Previous Message | Gustavsson Mikael | 2020-12-17 16:19:33 | SV: SV: Problem with ssl and psql in Postgresql 13 |