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.johns...@gmail.com>
Sent: Wednesday, January 19, 2022 4:26 PM
To: Capobianco, Tony <tony.capobia...@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 
<nore...@postgresql.org<mailto:nore...@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.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2F14%2Fruntime-config-client.html&data=04%7C01%7Ctony.capobianco%40bcbsma.com%7C0b31a25f295c4f8c524408d9db926143%7C7f6a7d1e1213434b981c95c72d65f665%7C0%7C0%7C637782244009710738%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=fp6dCoKy7OlzKjigp9NAVFysmd1maUxjuSmm8wp5k1k%3D&reserved=0>
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.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2Fcurrent%2Fruntime-config.html&data=04%7C01%7Ctony.capobianco%40bcbsma.com%7C0b31a25f295c4f8c524408d9db926143%7C7f6a7d1e1213434b981c95c72d65f665%7C0%7C0%7C637782244009710738%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=TTraQJtCJ29P%2FmaD7OCLkrV6JN7t0ElF6urEi2W61i8%3D&reserved=0>

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.

Reply via email to