Re: log ssl mode with connections?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: log ssl mode with connections?
Date: 2007-01-30 17:35:01
Message-ID: Pine.BSO.4.64.0701301232130.22818@leary2.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-01-30 17:39:26 "May", "can", "might"
Previous Message codeWarrior 2007-01-30 17:15:11 Re: SQL to get a table columns comments?