Re: Is the pg_isready database name relevant?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Is the pg_isready database name relevant?
Date: 2025-11-24 16:52:58
Message-ID: CANzqJaD+kp+zVy71d7mS4jo+9FzKfBtDG16XKcqJQxix2YwbOg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Nov 24, 2025 at 11:45 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Monday, November 24, 2025, Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:
>
>> On Mon, Nov 24, 2025 at 11:30 AM David G. Johnston <
>> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>>
>>> On Monday, November 24, 2025, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
>>> 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.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2025-11-24 18:18:04 Re: Is the pg_isready database name relevant?
Previous Message David G. Johnston 2025-11-24 16:45:53 Re: Is the pg_isready database name relevant?