May 11th, 2015 by depesz | Tags: , , , | Comments Off on Waiting for 9.5 – Add system view pg_stat_ssl

On 12th of April, Magnus Hagander committed patch: Add system view pg_stat_ssl This view shows information about all connections, such as if the connection is using SSL, which cipher is used, and which client certificate (if any) is used. Reviews by Alex Shulgin, Heikki Linnakangas, ...

I had to setup it relatively recently, and hit some roadblocks, so figured I'll write about my experiences - for myself in the future, or for anyone else that might want to set it up.