Re: Feature request: Logging SSL connections - Mailing list pgsql-hackers

From Dr. Andreas Kunert
Subject Re: Feature request: Logging SSL connections
Date
Msg-id 52A1AA6B.3010602@cms.hu-berlin.de
Whole thread Raw
In response to Re: Feature request: Logging SSL connections  (Marko Kreen <markokr@gmail.com>)
Responses Re: Feature request: Logging SSL connections
List pgsql-hackers
>> That seems useful.  Do we need more information, like whether a client
>> certificate was presented, or what ciphers were used?
>
> Yes, please show ciphersuite and TLS version too.  Andreas, you can use my
> recent \conninfo patch as template:
>
>    https://github.com/markokr/postgres/commit/7d1b27ac74643abd15007cc4ec0b56ba92b39d90
>
> Also, please show the SSL level also for walsender connections.  It's
> quite important to know whether they are using SSL or not.
>
> But I think the 'bits' output is unnecessary, as it's cipher strength
> is known by ciphersuite.  Perhaps it can be removed from \conninfo too.

A new patch is attached. I added the ciphersuite and TLS version like
shown in your template (minus the 'bits' output). I also added the SSL
information for walsender connections, but due to a missing test setup I
cannot test that part.

Anything else missing?

--
Andreas

Attachment

pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: [PATCH] Add transforms feature
Next
From: Hannu Krosing
Date:
Subject: Re: [PATCH] Add transforms feature