pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedidle_session_timeout doc
4+ messages / 3 participants
[nested] [flat]
* idle_session_timeout doc
@ 2022-01-19 20:13 PG Doc comments form <noreply@postgresql.org>
2022-01-19 21:26 ` Re: idle_session_timeout doc David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: PG Doc comments form @ 2022-01-19 20:13 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: tony.capobianco@bcbsma.com
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: idle_session_timeout doc
2022-01-19 20:13 idle_session_timeout doc PG Doc comments form <noreply@postgresql.org>
@ 2022-01-19 21:26 ` David G. Johnston <david.g.johnston@gmail.com>
2022-01-19 22:27 ` RE: idle_session_timeout doc Capobianco, Tony <Tony.Capobianco@bcbsma.com>
0 siblings, 1 reply; 4+ messages in thread
From: David G. Johnston @ 2022-01-19 21:26 UTC (permalink / raw)
To: tony.capobianco@bcbsma.com, Pg Docs <pgsql-docs@lists.postgresql.org>
On Wed, Jan 19, 2022 at 2:18 PM PG Doc comments form <noreply@postgresql.org>
wrote:
> 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:
>
>
https://www.postgresql.org/docs/current/runtime-config.html
Note in particular the ways of doing this via SQL.
Settings are best considered session-local with the initial value for a
setting in a session determined as described in the docs.
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: idle_session_timeout doc
2022-01-19 20:13 idle_session_timeout doc PG Doc comments form <noreply@postgresql.org>
2022-01-19 21:26 ` Re: idle_session_timeout doc David G. Johnston <david.g.johnston@gmail.com>
@ 2022-01-19 22:27 ` Capobianco, Tony <Tony.Capobianco@bcbsma.com>
2022-01-19 22:31 ` Re: idle_session_timeout doc David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Capobianco, Tony @ 2022-01-19 22:27 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; Pg Docs <pgsql-docs@lists.postgresql.org>
I have yet to find any instances where idle_session_timeout can be set at the session level or applied to a single user.
From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Wednesday, January 19, 2022 4:26 PM
To: Capobianco, Tony <Tony.Capobianco@bcbsma.com>; Pg Docs <pgsql-docs@lists.postgresql.org>
Subject: Re: idle_session_timeout doc
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
On Wed, Jan 19, 2022 at 2:18 PM PG Doc comments form <noreply@postgresql.org<mailto:noreply@postgresql.org>> wrote:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/runtime-config-client.html<https://nam10.safelinks.protection....;
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:
https://www.postgresql.org/docs/current/runtime-config.html<https://nam10.safelinks.protection.ou...;
Note in particular the ways of doing this via SQL.
Settings are best considered session-local with the initial value for a setting in a session determined as described in the docs.
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: idle_session_timeout doc
2022-01-19 20:13 idle_session_timeout doc PG Doc comments form <noreply@postgresql.org>
2022-01-19 21:26 ` Re: idle_session_timeout doc David G. Johnston <david.g.johnston@gmail.com>
2022-01-19 22:27 ` RE: idle_session_timeout doc Capobianco, Tony <Tony.Capobianco@bcbsma.com>
@ 2022-01-19 22:31 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: David G. Johnston @ 2022-01-19 22:31 UTC (permalink / raw)
To: Capobianco, Tony <Tony.Capobianco@bcbsma.com>; +Cc: Pg Docs <pgsql-docs@lists.postgresql.org>
On Wed, Jan 19, 2022 at 3:27 PM Capobianco, Tony <Tony.Capobianco@bcbsma.com>
wrote:
> I have yet to find any instances where idle_session_timeout can be set at
> the session level or applied to a single user.
>
>
>
https://www.postgresql.org/docs/current/sql-alterrole.html
https://www.postgresql.org/docs/current/sql-set.html
idle_session_timeout is one of many "configuration_parameter"
David J.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-01-19 22:31 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-01-19 20:13 idle_session_timeout doc PG Doc comments form <noreply@postgresql.org>
2022-01-19 21:26 ` David G. Johnston <david.g.johnston@gmail.com>
2022-01-19 22:27 ` Capobianco, Tony <Tony.Capobianco@bcbsma.com>
2022-01-19 22:31 ` David G. Johnston <david.g.johnston@gmail.com>
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