Re: log ssl mode with connections?

On Tue, 30 Jan 2007, Andrew Dunstan wrote:

> If I am allowing both SSL and non-SSL I might like to know which is used by a 
> particular connection.
>

Other places I've heard people ask for this info:

1) pg_stat_activity to see who's currently connected and how.

2) Via a function (boolean am_i_using_ssl()) so they can make security 
decisions in views or procedural code.

Kris Jurka