Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\))
Subject: Re: pgsql: Modularize log_connections output
From: Daniel Gustafsson <daniel@yesql.se>
In-Reply-To: 
 <CAAKRu_ZHECM5htitn09XyssxmQF9Jkpw+7EK4g5_VqEpkfQPBg@mail.gmail.com>
Date: Wed, 12 Mar 2025 17:36:40 +0100
Cc: "Daniel Westermann (DWE)" <daniel.westermann@dbi-services.com>,
 "pgsql-committers@lists.postgresql.org"
 <pgsql-committers@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <22D5E616-F460-467A-B913-32CCF1CDB884@yesql.se>
References: <E1tsO99-00277d-1W@gemulon.postgresql.org>
 <GV0P278MB041968707F13439C8E670752D2D02@GV0P278MB0419.CHEP278.PROD.OUTLOOK.COM>
 <CAAKRu_ZHECM5htitn09XyssxmQF9Jkpw+7EK4g5_VqEpkfQPBg@mail.gmail.com>
To: Melanie Plageman <melanieplageman@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/22D5E616-F460-467A-B913-32CCF1CDB884%40yesql.se>
Precedence: bulk

> On 12 Mar 2025, at 17:07, Melanie Plageman <melanieplageman@gmail.com> =
wrote:
>=20
> Thanks for taking a look!
>=20
> On Wed, Mar 12, 2025 at 11:50=E2=80=AFAM Daniel Westermann (DWE)
> <daniel.westermann@dbi-services.com> wrote:
>>=20
>>=20
>> great, thanks for this. One question:
>>=20
>>> The current log_connections options are 'receipt', 'authentication', =
and
>>> 'authorization'. The empty string disables all connection logging. =
'all'
>>> enables all available connection logging.
>>=20
>> ... shouldn't this be added to tab completion as well?
>>=20
>> postgres=3D# alter system set log_connections TO DEFAULT
>=20
> Because it is now a string GUC, there isn't a facility for tab
> completion.

This GUC also cannot be changed within a session which makes tab =
completion
less useful.

--
Daniel Gustafsson