From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: tony.capobianco@bcbsma.com
Subject: idle_session_timeout doc
Date: Wed, 19 Jan 2022 20:13:47 +0000
Message-ID: <164262322735.31954.5814862771892121460@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/runtime-config-client.html
Description:
Is there a way to alter users idle_session_timeout setting? My
understanding is that it's a global setting. The last sentence indicates
you can apply an idle session timeout to particular users:
idle_session_timeout (integer)
Terminate any session that has been idle (that is, waiting for a client
query), but not within an open transaction, for longer than the specified
amount of time. If this value is specified without units, it is taken as
milliseconds. A value of zero (the default) disables the timeout.
Unlike the case with an open transaction, an idle session without a
transaction imposes no large costs on the server, so there is less need to
enable this timeout than idle_in_transaction_session_timeout.
Be wary of enforcing this timeout on connections made through
connection-pooling software or other middleware, as such a layer may not
react well to unexpected connection closure. It may be helpful to enable
this timeout only for interactive sessions, perhaps by applying it only to
particular users.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, tony.capobianco@bcbsma.com
Subject: Re: idle_session_timeout doc
In-Reply-To: <164262322735.31954.5814862771892121460@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox