public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Ron Johnson <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Is the pg_isready database name relevant?
Date: Mon, 24 Nov 2025 12:18:04 -0600
Message-ID: <CAKFQuwa4tW-s0t6ezpbB21TOQEWupYJmXoU454aL3yG7WysGrw@mail.gmail.com> (raw)
In-Reply-To: <CANzqJaD+kp+zVy71d7mS4jo+9FzKfBtDG16XKcqJQxix2YwbOg@mail.gmail.com>
References: <CANzqJaAob4BFkhc2-w_vJrm-8KgELNnmqJJhc4oNDuY-O9+Azg@mail.gmail.com>
<CAKFQuwZyBkjLxYt5RpPVnbO_EMAyfYwp-XhSKeebRhyNFM9SVQ@mail.gmail.com>
<CANzqJaCSbqU3QUqMhfv5ivYww=JQNwyYnKWnEJoO_onCiCrhSg@mail.gmail.com>
<CAKFQuwaSepzY69Jod0wsPrh8Qmu_AdMoWaQ=kq3ifJWsuD+P3w@mail.gmail.com>
<CANzqJaD+kp+zVy71d7mS4jo+9FzKfBtDG16XKcqJQxix2YwbOg@mail.gmail.com>
On Mon, Nov 24, 2025, 09:53 Ron Johnson <[email protected]> wrote:
> On Mon, Nov 24, 2025 at 11:45 AM David G. Johnston <
> [email protected]> wrote:
>
>> On Monday, November 24, 2025, Ron Johnson <[email protected]>
>> wrote:
>>
>>> On Mon, Nov 24, 2025 at 11:30 AM David G. Johnston <
>>> [email protected]> wrote:
>>>
>>>> On Monday, November 24, 2025, Ron Johnson <[email protected]>
>>>> wrote:
>>>>
>>>>> The "-d, --dbname=DBNAME" option is mentioned in --help output, but
>>>>> pg_isready ignores nonexistent databases.
>>>>>
>>>>> Is this an application bug, a minor doc bug or am I missing something?
>>>>>
>>>>
>>>> It’s documented in the Notes section.
>>>>
>>>
>>> That seems odd. Why mention an option in --help if the option isn't
>>> needed?
>>>
>>
>> Because it exists - and I figure most people should use it to not put
>> spurious errors into the logs.
>>
>
> The person on the client side isn't thinking about what's going in the PG
> server's logs.
>
> This is something that *should* be fixed. Very low priority, after the
> data corruption and feature bugs, and useful new features added, but either
> return an error code if the client user doesn't have access to that
> database, or remove the option.
>
It reports whether the cluster is ready, not any specific database or for
any specific user. It works just fine for its intent. Sure, it could be
modified to also do something different. But you haven't explained why
that would be a worthwhile use of effort. All I'm seeing it admittedly a
slightly non-intuitative specification that does require reading and some
degree of caring on the part of the user. And probably some recognition
that it works this way because the backend protocol doesn't allow for those
values to be made optional and so the current implementation is a bit of a
hack to get around that fact.
David J.
view thread (11+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Is the pg_isready database name relevant?
In-Reply-To: <CAKFQuwa4tW-s0t6ezpbB21TOQEWupYJmXoU454aL3yG7WysGrw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox