Re: [GENERAL] idle in transaction, why - Mailing list pgsql-general

From Rob Sargent
Subject Re: [GENERAL] idle in transaction, why
Date
Msg-id e10eb101-676b-49f9-d704-b481ca0d533a@gmail.com
Whole thread Raw
In response to Re: [GENERAL] idle in transaction, why  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general

On 11/06/2017 01:09 PM, David G. Johnston wrote:
On Mon, Nov 6, 2017 at 12:32 PM, Rob Sargent <robjsargent@gmail.com> wrote:

Using postgres 10-beta3 (hopefully 10.0 this week) on virtual CentOS7 and this JDBC driver postgresql:42.1.4


The postgresql.conf file has

#idle_in_transaction_session_timeout = 0        # in milliseconds, 0 is disabled


​There are numerous places where default settings can be configured.


You should probably login as your application user and do "show idle_in_transaction_session_timeout" to see what a clean session has for a value and then figure out from there where that value is coming from.

David J.

From logging in with the application role I get
coon=> show idle_in_transaction_session_timeout;
 idle_in_transaction_session_timeout
-------------------------------------
 0
(1 row)

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] idle in transaction, why
Next
From: Rob Sargent
Date:
Subject: Re: [GENERAL] idle in transaction, why