MIME-Version: 1.0
References: <997377b9-b2c7-452d-75af-eca6668d6e77@uni-muenster.de>
In-Reply-To: <997377b9-b2c7-452d-75af-eca6668d6e77@uni-muenster.de>
From: Robert Haas <robertmhaas@gmail.com>
Date: Wed, 4 Oct 2023 16:18:50 -0400
Message-ID: <CA+TgmoZw9DpGOsdF6ROO_o9YtTEH2j0k7b_0iALM5Z9=VQDbTQ@mail.gmail.com>
Subject: Re: Add annotation syntax to pg_hba.conf entries
To: Jim Jones <jim.jones@uni-muenster.de>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Daniel Gustafsson <daniel@yesql.se>, 
	Peter Eisentraut <peter@eisentraut.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BTgmoZw9DpGOsdF6ROO_o9YtTEH2j0k7b_0iALM5Z9%3DVQDbTQ%40mail.gmail.com>
Precedence: bulk

On Wed, Oct 4, 2023 at 4:06=E2=80=AFPM Jim Jones <jim.jones@uni-muenster.de=
> wrote:
> Any thoughts?

You're probably not going to like this answer very much, but this
doesn't seem particularly worthwhile to me. If somebody needs to
document why they did something in pg_hba.conf, they can already put a
comment in the file to explain that. Or they can track the reasons for
what's in the file using some completely external system, like a
Google document or a git repository or whatever. The argument for this
feature is not that this information needs to exist, but that it needs
to be queryable from within PostgreSQL. And I guess I just wonder if
that is something that users in general want. It's not a terrible idea
or anything, but it would be sad if we added such a feature and you
were the only one who ever used it... and if a bunch of people now
show up and say "actually, this would be great, I would totally like
to have that," well, then, forget I said anything.

--=20
Robert Haas
EDB: http://www.enterprisedb.com