Re: [GENERAL] idle in transaction, why

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.

https://www.postgresql.org/docs/10/static/config-setting.html

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.

coon=> show idle_in_transaction_session_timeout;
 idle_in_transaction_session_timeout
-------------------------------------
 0
(1 row)