Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAJVv-0003u3-Rn for pgsql-docs@arkaria.postgresql.org; Wed, 19 Jan 2022 22:33:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nAJVu-0006SW-ON for pgsql-docs@arkaria.postgresql.org; Wed, 19 Jan 2022 22:33:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAJQe-00031R-Lc for pgsql-docs@lists.postgresql.org; Wed, 19 Jan 2022 22:27:45 +0000 Received: from bcbsma.zixworks.com ([173.226.139.14] helo=z132.zixworks.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nAJQb-00012s-JR for pgsql-docs@lists.postgresql.org; Wed, 19 Jan 2022 22:27:43 +0000 Received: from 127.0.0.1 (ZixVPM [127.0.0.1]) by Outbound.z132.zixworks.com (Proprietary) with SMTP id 68F672444E for ; Wed, 19 Jan 2022 16:27:40 -0600 (CST) Received: from NAM10-MW2-obe.outbound.protection.outlook.com (mail-mw2nam10lp2105.outbound.protection.outlook.com [104.47.55.105]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by z132.zixworks.com (Proprietary) with ESMTPS id 58BC52257C; Wed, 19 Jan 2022 16:27:39 -0600 (CST) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=G2BApfWkgyOJmBmeuHn4KX+R0OPIM2nVeamAovrcgP340OapMLHhlDzqAvFLaLhH/Iy4lX4AQqO2fM3+T1x6qCYAmRGTLD+rUskFSRi6NveNW7ApFo6hcWEXD19VqK7Z3pNLNQIMY2+Vq3DkkAUNE3g+mzqDtd458j7xDAcTlkNcdVCQU3PuvEi7i1i/2+y2Du3ycoOujlhM6PyyqITXQmKUsdMgBBEE8bvJ6s0OAyXI+O3yCNFHbZ/98lfrXzBzlgIbo36SEa/JZ/NK65sAIdIn/3XtZuKaE2S23iTAOth92xGA8laDuTxKKFCDzpslYExmeiH1dpoYgqRqqRQAFg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=g9dvzcNkN9o152EOpiZXyvKSCnde7QXsiWgGFSO5svo=; b=HvUOQdH1tL97TpLEMU4TOe5BFjjqW2jlPUVA84OQU65abeqZnixnUPF7hzaVWPHZirhoKWgoN87vMGIqq/AK/DlsWG6Np6boImzERiyp/Cn4X1+jnzoVjv+Re3VrtWGgJqVLwLirl6RAEET8WZrb6+FFgjerbahdk6uL/0uS99gBkLrjNqsa6Mb+hNB235Vp9gQplBo3qwxJlWDKwXUvQsNYHPe+a6SuTvnnG7elKQl0XE0zrgkQEgguPnE7gfI0+LwKeZ0hlgsIV4eluGDVoU/Q+JRHo70DkB0kbwNziOT9mEhQOK++pX/izz1QS05miPHcjjiqd7UmlsLw0pu/rw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bcbsma.onmicrosoft.com; s=selector2-bcbsma-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=g9dvzcNkN9o152EOpiZXyvKSCnde7QXsiWgGFSO5svo=; b=HRMN7X3DOQ+pRmwjQBEnVSnZDhD+ap3DPl0A/tvpkezx4N59fRK0NXZraaKBicxPPMoMzFQIO4GRSCSRQINsHwgK4I6ewX+8NLDy+OB4uVdFZzMjvfnBmh42kj3mTc4DIdczp0QF34JAckpCKBORIW8NVc3Ur5YcRl1xkq3zuIw= Received: from BLAPR13MB4660.namprd13.prod.outlook.com (2603:10b6:208:321::8) by SJ0PR13MB5895.namprd13.prod.outlook.com (2603:10b6:a03:439::11) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4909.4; Wed, 19 Jan 2022 22:27:37 +0000 Received: from BLAPR13MB4660.namprd13.prod.outlook.com ([fe80::5020:99c1:47b5:9b6e]) by BLAPR13MB4660.namprd13.prod.outlook.com ([fe80::5020:99c1:47b5:9b6e%7]) with mapi id 15.20.4909.008; Wed, 19 Jan 2022 22:27:36 +0000 From: "Capobianco, Tony" To: "David G. Johnston" , Pg Docs Subject: RE: idle_session_timeout doc Thread-Topic: idle_session_timeout doc Thread-Index: AQHYDXE4sWk6vBXVFUGRcfibO1+IRqxq24QAgAAKuCA= Date: Wed, 19 Jan 2022 22:27:36 +0000 Message-ID: References: <164262322735.31954.5814862771892121460@wrigleys.postgresql.org> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-dg-ref: PG1ldGE+PGF0IG5tPSJib2R5Lmh0bWwiIHA9ImM6XHVzZXJzXHRjYXBvYjAxXGFwcGRhdGFccm9hbWluZ1wwOWQ4NDliNi0zMmQzLTRhNDAtODVlZS02Yjg0YmEyOWUzNWJcbXNnc1xtc2ctZmZkMDNhNjYtNzk3Ni0xMWVjLWI2YzktMDhkMjNlMjBmMzA5XGFtZS10ZXN0XGZmZDAzYTY4LTc5NzYtMTFlYy1iNmM5LTA4ZDIzZTIwZjMwOWJvZHkuaHRtbCIgc3o9IjU1NzEiIHQ9IjEzMjg3MTA0ODU1NjcwMTc5NyIgaD0iSUYwS1lndytLKzcraEFSTHFLeHllYkRwV2lFPSIgaWQ9IiIgYmw9IjAiIGJvPSIxIi8+PC9tZXRhPg== x-dg-rorf: true authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=bcbsma.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: bd574481-d050-4854-bd56-08d9db9ae563 x-ms-traffictypediagnostic: SJ0PR13MB5895:EE_ x-microsoft-antispam-prvs: x-bcbsmarule-messageencryptionremoval: Rule Triggered x-ms-oob-tlc-oobclassifiers: OLM:9508; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: /xJW4SohdSpShjnkyBxZKBaNyraxvrj0raIHel8kd0w345g1piVdf0hvfKy/TR71TBqFRG2m4bat4Kpvp+PqogcJnWYfbwRdEhBiS/E7PcwS3M4ONDeNx3Gw6YMb5aoDgagdcCcMeF1zJIIv6D7/bVYF9Q3py7a7JM2833qjF6SQ64rcLNkvcbOGTzdEwW0AVVjQd9JqPJqy73rV+DYmmsaV4iOE9eDISVC3N3jld8gvoG7GReWL1e921ZPQa6v6INklhq1e0+ggPxjBH/DRBFHS0JtBru8wVmtSAMjdD8gBxJwZnAnl2hERYZoHlt28ST8X3hP7M4z29FeTKLzbAlRZqs+WRn7VyToR3Pue7XDqg8aAi1AaQpao6U/vWTebqTsdVOCkXCWo82WUiLk1IdKVhY6MvPN+xJzTF0MemlnPkVFVL7a3k37cPFzp7kq8UzZDerLjChkK3y69vPjfkAcgyF3fsxbjV4+C3DkEmv70pcUX4uM/CQXmjhIfsy35HDAnh9axsARmVkv2R6IQxct1aLecCNC1LY/MlxMGoUeJJqUt7CwwwNX3YqrZXu1Aau5yECD0Gfb9z39fmNskx+qH4xrrYFO34Wz4bletgRv8wthor9WIpvfR/bH4yDfGZpZKWVFAKaU8I6tiHYtTSwZNcsGz0WoWZD8fR2JBNJGNyhv5tENK9ZA/fIH3Q1xBqXVY8E5Q7QJwdtEWgFQXamthueCSvhcLrab9mWXZGS9qUsb3WlynX9Jvi0igJSbmxpoG1qQ2CJwKMcCGU3QIwml4d+lEWi7DLPRxK6OEEEA= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:BLAPR13MB4660.namprd13.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230001)(4636009)(366004)(316002)(166002)(966005)(86362001)(55016003)(52536014)(66476007)(8936002)(38070700005)(66446008)(7116003)(64756008)(110136005)(8676002)(76116006)(66556008)(38100700002)(5660300002)(66946007)(26005)(71200400001)(33656002)(9686003)(6506007)(122000001)(53546011)(7696005)(186003)(2906002)(508600001)(20210929001);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?WClyysC+Js5+BXlvyNth0k6m1hYGEaS+PmV/xkV4EDMUZaYvktl1X35ZOAwX?= =?us-ascii?Q?SDgd0m2Tf1YSqnZmhfIfl841JVV/yn4vR8dFqREiBaB9zt3Z7/VA6IS9gECD?= =?us-ascii?Q?i9n3rgDUeGrJmaLBZunUv42PIz6fNzv6Co2m2IPlLAqyw0UNIh8mc/uuPKP/?= =?us-ascii?Q?HsoivLVW6OEa2+MJA3H8mVnkWa9diOt48nmEy6hfKncSM4o4o8cwc/VDB47q?= =?us-ascii?Q?Op5vcMJ0fmGt2wEBNwCq4ZWuuZq4h7OMs0w2aLhXOa/aMDexzbDTfRWGJJap?= =?us-ascii?Q?zjsn9v0FMFQKvI7zjPOWgiN6bsEavL1tnpkFRfrEFJfAWP5eemWhwvLPKoqW?= =?us-ascii?Q?k3vnSqv1L4dNwfZbiIfpkhBuMjKPcQMfR+PyXJBHPZ6pUnk1HgB75Nj+tteI?= =?us-ascii?Q?B7xrPcHNIYX9DCE5OzAFNkTtzXf5ViOd/BCw4RUL7E1PoVYMxUc8Gc3SA8gX?= =?us-ascii?Q?o2Gy/REBznnV8dUwmQe7+ERz0xA0VfECPdqGqtNjGh+eZDZMB8Ksoqz+D7GC?= =?us-ascii?Q?vD+jrxtZpue5+gwUx82w5vb8Ks9vYeQEVXjBvWF6j9BTekUybKOmpyVfaibe?= =?us-ascii?Q?FePco17+aeCbQonvrDC0sWvp1YyrzfnpxyE3ewRIh4UBLvG2oxl8r6UzJxJs?= =?us-ascii?Q?pgpXHFM8nakXA0gdgsB+UW40FdFTlfCvREwzGd5y4fDOrahPSYsI6Dev76/v?= =?us-ascii?Q?5ktdg+CcKdtXQeNxupk3UoVJ5NRfufU01/tKpLS0JsY0/ef7qcVSSb3r2dI3?= =?us-ascii?Q?EYql2WHxRGGbBKZkwZ9x7yylSVHr8qD2+0e2dtsi4bkJTc9CAxVdDpec2rYF?= =?us-ascii?Q?FWrLqrCtV5Yb1XGLRpqZpKotP8dbwDHpuyUQZP61+ZwhH5NEB6TmA/gHNRwh?= =?us-ascii?Q?aZFk/dcrYIT+5rmFLPRUYTxS5stFgu3ra/BXhs8X4LJVh7uioOwx25A7nzjv?= =?us-ascii?Q?dfIqAdCd9SuYK0CSP/MecNvQfJ6QfpVaI41Ci77RNnT7Mf+bMqvWO2KmlOhE?= =?us-ascii?Q?0caFVVLDfEaYj4ppWjnbiQsRMa8kDyhmMocRaGpNNC/EJ1Q9IKt5ExLrJo1v?= =?us-ascii?Q?dOwm4E10DkXJxR5JT5KPYf05VzRNTqhhWZ15XxptVvrOc5/C3nUW89fnC3jQ?= =?us-ascii?Q?7LUDC3pqaMoyOZ/SoEN9JGdGSKNMrPJ9i53T5aA0QGw1V5He6z0TJLJxKKbu?= =?us-ascii?Q?yZ9YOgNAr25xqnEzk5z126szkBggLzcJguD6guxVmT+2IqoZqctaEOQ2KB2S?= =?us-ascii?Q?Lg5I/zmumJsfdud9XGtpCl13M+rByGPzQ+LqKDsh0lgbPF5Z8yl4i+WYKchH?= =?us-ascii?Q?kIVTYwgLdJFstIowx28qNT2Ie3PEyUSNpuc7SiqInah7x6DDKcK6JvYAnE/8?= =?us-ascii?Q?CI4P2fzc51b9fhIj2xY0d5UY15BwWXFd8GQfip4Z29rjN9RABiFpMpQtuhOI?= =?us-ascii?Q?yzCWIusD9sqStwd7YZus3FTpNFt3QVbrfDcCW4vvmdbbIKRGxl8cu5tg4DBK?= =?us-ascii?Q?dvmtyatWv3pQZ48z8eLNn2nVkYtx6cuUbaueGSUOnC4/sHWp/UR891uQiXBD?= =?us-ascii?Q?FHHx9/CelOGLvXG+xsjDvGYsEwFdmVQ5TKXVdK8t92p2GQXiRFOiE0ldGUsf?= =?us-ascii?Q?Gx4jF+qhQrVLkUyHZBmjGeI=3D?= Content-Type: multipart/alternative; boundary="_000_BLAPR13MB4660958292104FDC74261ADC9E599BLAPR13MB4660namp_" MIME-Version: 1.0 X-OriginatorOrg: BCBSma.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: BLAPR13MB4660.namprd13.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: bd574481-d050-4854-bd56-08d9db9ae563 X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Jan 2022 22:27:36.7726 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 7f6a7d1e-1213-434b-981c-95c72d65f665 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: yYgDgs6cnJUTDobEMtR2XZpAckNE7WQzrZh526aSK2HeJdqhoc81akA3vQ6SqK+i9/L2c+Ljt+pLkfLaEcz3eA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ0PR13MB5895 X-VPM-HOST: vmvpm03.z132.zixworks.com Cc: X-VPM-GROUP-ID: d0a93a09-1781-46e3-a367-35d456925ed1 X-VPM-MSG-ID: e096a739-18d0-46d6-873f-5dc98604662b X-VPM-ENC-REGIME: Plaintext X-VPM-IS-HYBRID: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_BLAPR13MB4660958292104FDC74261ADC9E599BLAPR13MB4660namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I have yet to find any instances where idle_session_timeout can be set at t= he session level or applied to a single user. From: David G. Johnston Sent: Wednesday, January 19, 2022 4:26 PM To: Capobianco, Tony ; Pg Docs Subject: Re: idle_session_timeout doc CAUTION: This email originated from outside of the organization. Do not cli= ck links or open attachments unless you recognize the sender and know the c= ontent is safe. On Wed, Jan 19, 2022 at 2:18 PM PG Doc comments form > 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 set= ting in a session determined as described in the docs. David J. --_000_BLAPR13MB4660958292104FDC74261ADC9E599BLAPR13MB4660namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

 

<= span style=3D"font-size:10.0pt;color:#9C6500">CAUTION: This email originated from outside of t= he organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.<= o:p>

 

On Wed, Jan 19, 2022 at 2:18 PM PG Doc comments form <noreply@postgresql.org> wrote:

The following documen= tation 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 indica= tes
you can apply an idle session timeout to particular users:

 

 

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.

--_000_BLAPR13MB4660958292104FDC74261ADC9E599BLAPR13MB4660namp_--