Re: How to check is connection encrypted - Mailing list pgsql-general

From Andrus
Subject Re: How to check is connection encrypted
Date
Msg-id 60A09E32534D41AE9A3E370973FE5B30@dell2
Whole thread Raw
In response to Re: How to check is connection encrypted  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi!

>Or, if you want to check/enforce this from the server side,
>you could enable log_connections and see what's logged;
>or simply change pg_hba.conf to disallow non-SSL connections.

I set log_connections =on

pg_hba.conf contains :

local   all             postgres                          trust
local all all md5
hostssl yle all 0.0.0.0/0 md5
hostssl yle all ::1/0 md5
host yle testuser 0.0.0.0/0 reject
host yle testuser  ::1/0 reject
...

log file does not show ssl connection info:

2019-03-22 16:49:03 EET [unknown]       [unknown]               LOG: 
connection received: host=xx.xx.xx.xx port=54590
2019-03-22 16:49:04 EET testuser        yle             LOG:  connection 
authorized: user=testuser database=yle

Why Postgres 9.1.5  version does not show ssl connection info here ?
Does this mean that there is no SSL connection or is ssl info logging added 
in newer versions ?

Andrus.



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Script which shows performance of ByteA: ascii vs binary
Next
From: Tom Lane
Date:
Subject: Re: How to check is connection encrypted