From: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>
To: Melanie Plageman <melanieplageman@gmail.com>,
	"pgsql-committers@lists.postgresql.org"
	<pgsql-committers@lists.postgresql.org>
Subject: Re: pgsql: Modularize log_connections output
Thread-Topic: pgsql: Modularize log_connections output
Thread-Index: AQHbk2SwgCxv4bJBW0aff+AX0A4IAbNvpBEh
Date: Wed, 12 Mar 2025 15:50:32 +0000
Message-ID: 
 <GV0P278MB041968707F13439C8E670752D2D02@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
References: <E1tsO99-00277d-1W@gemulon.postgresql.org>
In-Reply-To: <E1tsO99-00277d-1W@gemulon.postgresql.org>
Accept-Language: en-US
Content-Language: en-US
msip_labels: 
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=dbi-services.com;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: GV0P278MB0419:EE_|GV0P278MB0177:EE_
x-ms-office365-filtering-correlation-id: cb949b7e-d53d-461d-eb7c-08dd617d9ef5
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230040|376014|366016|1800799024|38070700018;
x-microsoft-antispam-message-info: 
 =?iso-8859-1?Q?QQwx26Cj6KNscZMAMOPUAWE6wJEhqcNMInvtUG1ClPZYTlIY6Hl19xXxvD?=
 =?iso-8859-1?Q?SQrkQl8WAGTVBC93k8g8QwqMMITYJdQRiq8xLJOmWf4yEfA+syM8yrjo+P?=
 =?iso-8859-1?Q?JCzM+Ii98Uo3E+Td52sR9DjWJCBW0NN7j+2imowM2eH/z7TyIG2k3/luLb?=
 =?iso-8859-1?Q?1bp5zATb3XHyQ/47N5TtlZh0iNvtaPkdIf88rcsmZ2Z7rjtxOOLVU/P0X3?=
 =?iso-8859-1?Q?6mPee0JE5ib8v+UE2/KPUMKq0aK4Gm6/RzQAaWaZPe0kMp4PP6CWDwmBa/?=
 =?iso-8859-1?Q?nVhiPGIXELu9Gdhx1vKF8DBQGlmErUkuW6Gq4s2x7nuPwcXnoQa9ImqNyP?=
 =?iso-8859-1?Q?KGjtmfQBH+3zU/uhBVIp7FQdbEnpY8V6/VnRJKAPTiV7vvYx/bUqXwNZ5n?=
 =?iso-8859-1?Q?rfDjDQMicCcUM55u+aU20VGJiWvS7OWl2bQvizJEV98h75VTFhPvM7jiEn?=
 =?iso-8859-1?Q?mbSX8gn4rChc+h8WY+UdSM7Zp+EjUsBR3OTeS62M7eEERRxeYmNYi460kR?=
 =?iso-8859-1?Q?WDLgc/71kom2qTBrKyDBj3TLmfYS+0uOGz4lcjPMSEuP+tdD7BerflvipA?=
 =?iso-8859-1?Q?1lRG8mfIJYOrCuxjzePWrxSITgkh1skoOuihW4YD72kw7dRSB4VKU+H6vQ?=
 =?iso-8859-1?Q?0dpYvZZAMojIrssjcOkpzZPbFsZI5xAzuI63IcRePa4vkI1iZsmTYYWxRk?=
 =?iso-8859-1?Q?jR8gYLl8uVvAPvm2HU89GeNr8QLDr/eM+MNt/VEGjrGR/9CCsl1Yq9xNm4?=
 =?iso-8859-1?Q?TpM0y9v2RdLnIsX9zOg/GAwcOr07jleJmn/is/AULTYWeeZJTy7vzoDXdf?=
 =?iso-8859-1?Q?dOWWDGT4UfALrnTJBuK0pNUR9s9Dm4zBOs8OwNVZPN+N/07qVhgPEkUv/B?=
 =?iso-8859-1?Q?SDU1qkDK/MNm7TkYmB0WJh+fPKjJlrZGe/ZhKVarGXjEAebGKmDOG5i68Z?=
 =?iso-8859-1?Q?A0HQc9GaD0gVmMpvZD0XqP1nBv4jJuCqD0yBVLIp1UMP3Cf6ioILWbBRjq?=
 =?iso-8859-1?Q?Jbk7vsIEYvoBUvbZgWrdIkGbaCSxcajuudXTrZO5FAqouxp3u76IY5Puam?=
 =?iso-8859-1?Q?IjltXW0VN/etzZROzo61VH3pzM7QK8VxPwqzXzO0esOs2Mc0QIRtXInVfn?=
 =?iso-8859-1?Q?b2IFUBozrW+KyRVvCJtTFCeIRIGIgq2i01RAFNOQPjvk65AJOoO7V+yONn?=
 =?iso-8859-1?Q?vFb2VMInMw9HuhS/P675pDkjpoaJ3oQiWsA3c2ZLKptoeYIFKntZkAjubL?=
 =?iso-8859-1?Q?QEG/xxf1og1z4r/EtSMIq62uNKeHRlhrwumQb1jifSYLWI7b2HbCya8V+t?=
 =?iso-8859-1?Q?uIKEf26vo66ZHfM9bwTsUoGT8vwZk9FMv0ik7j1Fzpy7ozrHfw0gSL7IqW?=
 =?iso-8859-1?Q?gJ52r+mRXd+Iu6Ml1J/WRvdPZ6ivsUN3jrh4ywD7vU3Slb4kyLGD8fIxuM?=
 =?iso-8859-1?Q?dtAyjw8rDQdZawPP1UV0i3jDXcSTC6h+sqlzJVG6qwqdMCC3PfLA9G/y7V?=
 =?iso-8859-1?Q?wdq+QXi5u8MOseeiL8kXYb?=
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(376014)(366016)(1800799024)(38070700018);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?iXMMNyBkwY4oxHZhEXrZnitm3ByHPVs5qhxeZNyhnN2G0jY8Wg+lRiaMD1?=
 =?iso-8859-1?Q?cs25bIhfliwlbiUysSytV78jHxj1x9CLtmlTUCnWk9AQgczA0VRZzcOp/8?=
 =?iso-8859-1?Q?nWG6gMejj4ZbMKHJnB6mQ55ZtVMMYhvrjS1itPirgz46sGy2op65o0g+8Z?=
 =?iso-8859-1?Q?ZiA5I2T17nDrpXAJ9V5D057dzoU+N4NapaHS+IXAxnHXQdAx5CeUgJ9G6P?=
 =?iso-8859-1?Q?rYPCovWJOCdQZ+arRhy9AN4hp1fDTfhHpD4M397wmeqxcKk+ypH7tFXSLq?=
 =?iso-8859-1?Q?13kWP/J6yuNLFAIW7IUBkmcl+kSJSjQ2h+ip2012JQX1M4cQsRJIbHOfDQ?=
 =?iso-8859-1?Q?GCWTKaLJnWefOHOksuDcEkfFbBPy3eNy8KU3K6ykyVMhwosHmVxeff8Enr?=
 =?iso-8859-1?Q?CCB4KeMFWxcM4mE3O+rJfLv2QebYQ8AenfhsyipcPQx/tKV8W0K61DOyn9?=
 =?iso-8859-1?Q?ytoHuHn/K/gYX6qv+Fd4upVmtkzmFSYnx3wc9feqsZh2p7ZlrsKQ/dc8SL?=
 =?iso-8859-1?Q?60IJeJl6sWjbCPDxiGmEPEsJLP9xc/+EQuPn3HoIsjTGzskcKvWmRazaI8?=
 =?iso-8859-1?Q?EztmXsuy47rh3A0XR/Oidq6vqy+WZr37MkFGWaAq/INdAArtgG6411uG0k?=
 =?iso-8859-1?Q?/+mHRxnj2HrlWEWkahEBCy+jyMG3Uo43pXPOFh3hb5CTO+RYkrDkyeGZRe?=
 =?iso-8859-1?Q?LjUTEX6KhoLOpAJTckyQJA7iIGQyWZgqn7fy1bgffbX8aBRVM1GlaG2N5m?=
 =?iso-8859-1?Q?IqAVIyuz0JwfHtFWmxApetBl0ToVqWx7VAlEZ7M7PNcuuPH9m9C+MCweFm?=
 =?iso-8859-1?Q?IAsVpQL+n8V0jnHOATMRYuoQLmY1Hb8Hyg7VLqnqXipTN3PeNbTb2aiVFa?=
 =?iso-8859-1?Q?7Hg8Y5rtDSrKRbOm7Hqe+a6DTTL82SF0dGXH4SQ3UTrVXLXKKtSAxo+bbz?=
 =?iso-8859-1?Q?Vmc2LFOd1bt1K3vbE2sFmAwY75GUT/zM96uKjfKhFv04kpMwCVsD7dWz2m?=
 =?iso-8859-1?Q?cKMbeYZemAtQqr5z0fAJjAMi4KOFNvvPzFQ4kZt0fe7WcXZ4JWjLKLdHdd?=
 =?iso-8859-1?Q?sJH6BNz9X2XN2wyeIt+zVmIA88AEofLDjeh4J/eR+MWY/E+0BIvio/iasp?=
 =?iso-8859-1?Q?xyR2RR8HufeCeG6eYT5Gb6qdlxWxidAo8SXk3HiIqeIrcIk7qqnJzdAYY+?=
 =?iso-8859-1?Q?IZzW+TTriuhsouUq4CkBRLDZ9nQDqvCOAooIWVqeZlLmKog14CsgY0Tdv5?=
 =?iso-8859-1?Q?rmi1ejXx3cKfLAmOA+c0pjQReiHPt8sa0FhDt7dcKDMscpNqpkyFD7im0p?=
 =?iso-8859-1?Q?0z2sMYvT+wsSjCemBWpNaWJxQpLmzZ/J8YyYVVHteCJ4Fe+JoKETBjVrht?=
 =?iso-8859-1?Q?X3cNxFO7+PE+6vFe5buUym2ZZahLdJbMyJYTT5Brqgex5s5RgHGVDFJet9?=
 =?iso-8859-1?Q?2cZojFphtBKBWzamU3H5NWz0fcJs0fX+8GGfrop1zHbtg0qKrUzMlPelWG?=
 =?iso-8859-1?Q?U1APsnHgWA+VeX2diMvTVExgz7LCZwKPlt5QqhwY7SnR7hC7ag+ukjkvcf?=
 =?iso-8859-1?Q?rpvVKClW8NBKlWW8C//JqZH9x+k0KUM8L2vFjHvql8VrxyfllTFfkBUJLa?=
 =?iso-8859-1?Q?R62g6xuu0rUTbgPZC3DYj5hrWExvfs8jixD7F7loFLlRKu1GZydRrjmw?=
 =?iso-8859-1?Q?=3D=3D?=
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: dbi-services.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 cb949b7e-d53d-461d-eb7c-08dd617d9ef5
X-MS-Exchange-CrossTenant-originalarrivaltime: 12 Mar 2025 15:50:32.1885
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: b9c70613-b1ea-47b7-9fdd-e6f3a67ce75c
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 BiXuDRyzDlAWpZMqkZ0UVaoEdNlX+bseM/mkUd691hPyDD77Dfcwfqk/WcsNNh7nReZjfxUgdpDh9gufBQDlWr4tiOpWkLQQ88cxnCQkDVyvMjZb0xkPebuDBm9Fe2s8
X-MS-Exchange-Transport-CrossTenantHeadersStamped: GV0P278MB0177
List-Id: <pgsql-committers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-committers@lists.postgresql.org>
List-Owner: <mailto:pgsql-committers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-committers>
Archived-At: 
 <https://www.postgresql.org/message-id/GV0P278MB041968707F13439C8E670752D2D02%40GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
Precedence: bulk

Hi,=0A=
=0A=
great, thanks for this. One question:=0A=
=0A=
>The current log_connections options are 'receipt', 'authentication', and=
=0A=
>'authorization'. The empty string disables all connection logging. 'all'=
=0A=
>enables all available connection logging.=0A=
=0A=
... shouldn't this be added to tab completion as well?=0A=
=0A=
postgres=3D# alter system set log_connections TO DEFAULT =0A=
=0A=
postgres=3D# alter system set log_disconnections TO =0A=
0        1        DEFAULT  FALSE    NO       OFF      ON       TRUE     YES=
      =0A=
postgres=3D# alter system set log_disconnections TO =0A=
=0A=
=0A=
Regards=0A=
Daniel=