RE: idle_session_timeout doc

From: "Capobianco, Tony" <Tony(dot)Capobianco(at)bcbsma(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: RE: idle_session_timeout doc
Date: 2022-01-19 22:27:36
Message-ID: BLAPR13MB4660958292104FDC74261ADC9E599@BLAPR13MB4660.namprd13.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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(dot)g(dot)johnston(at)gmail(dot)com>
Sent: Wednesday, January 19, 2022 4:26 PM
To: Capobianco, Tony <Tony(dot)Capobianco(at)bcbsma(dot)com>; Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)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(at)postgresql(dot)org<mailto:noreply(at)postgresql(dot)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.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2022-01-19 22:31:57 Re: idle_session_timeout doc
Previous Message David G. Johnston 2022-01-19 21:26:20 Re: idle_session_timeout doc