Re: [HACKERS] log ssl mode with connections?

2007-02-21 Thread Henry B. Hotz
Anyone making those kind of decisions probably wants a generic "connection is encrypted" flag. It could be true if a GSSAPI connection has negotiated use of a security layer. Of course I don't have my GSSAPI patches working as well as the SASL ones were yet, and I haven't started on adding

Re: [HACKERS] log ssl mode with connections?

2007-01-30 Thread Magnus Hagander
On Tue, Jan 30, 2007 at 12:35:01PM -0500, Kris Jurka wrote: > > > 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_ac

Re: [HACKERS] log ssl mode with connections?

2007-01-30 Thread Kris Jurka
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_

Re: [HACKERS] log ssl mode with connections?

2007-01-30 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: I just turned on SSL for a test server and noticed that SSL mode isn't logged with the connection. Should it be? Why? If I am allowing both SSL and non-SSL I might like to know which is used by a particular conn

Re: [HACKERS] log ssl mode with connections?

2007-01-30 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > I just turned on SSL for a test server and noticed that SSL mode isn't > logged with the connection. Should it be? Why? regards, tom lane ---(end of broadcast)--- TIP 6: explain

[HACKERS] log ssl mode with connections?

2007-01-30 Thread Andrew Dunstan
I just turned on SSL for a test server and noticed that SSL mode isn't logged with the connection. Should it be? It should be relatively simple to add. cheers andrew ---(end of broadcast)--- TIP 6: explain analyze is your friend