Re: Idle In Transaction Session Timeout, revived - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Idle In Transaction Session Timeout, revived
Date
Msg-id 20160204100058.GA220738@alvherre.pgsql
Whole thread Raw
In response to Re: Idle In Transaction Session Timeout, revived  (David Steele <david@pgmasters.net>)
Responses Re: Idle In Transaction Session Timeout, revived
List pgsql-hackers
David Steele wrote:

> > <...> But what I think really happens is
> > some badly-written Java application loses track of a connection
> > someplace and just never finds it again. <...>

I've seen that also, plenty of times.

> That's what I've seen over and over again.  And then sometimes it's not
> a badly-written Java application, but me, and in that case I definitely
> want the connection killed.  Without logging, if you please.

So the way to escape audit logging is to open a transaction, steal some
data, then leave the connection open so that it's not logged when it's
killed?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Idle In Transaction Session Timeout, revived
Next
From: Alvaro Herrera
Date:
Subject: Re: pgbench stats per script & other stuff