public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Ron Johnson <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: pgping?
Date: Sat, 13 Dec 2025 22:59:44 -0700
Message-ID: <CAKFQuwa3ZswZJ13BmEtN8mRMfv3EkbUzD8bQOOKs9uBCqF5RDg@mail.gmail.com> (raw)
In-Reply-To: <CANzqJaC=qfACMk4Us4CcP1ryjLWk2YQzLcRrRh34FRG6OVUWpA@mail.gmail.com>
References: <CAPdrarpx11sa=W2dQhLAhQGQ=2a_wtMmB8KPqEY-C4ZbJem1JA@mail.gmail.com>
	<CANzqJaApzEfVtBqvitzFunaVNpwTDy=rNorXm0_YAuCFVO_c=w@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<CANzqJaCg=4hPD8Tyn7ohz3hNMQG6=dhVPqEK-5qpnDKpR0W=RQ@mail.gmail.com>
	<CAKFQuwY9iMKOhnf+3Xy+18CmEEKpjNen9F8PE0gjgqPcyd=OuQ@mail.gmail.com>
	<CANzqJaC=qfACMk4Us4CcP1ryjLWk2YQzLcRrRh34FRG6OVUWpA@mail.gmail.com>

On Sat, Dec 13, 2025 at 3:27 PM Ron Johnson <[email protected]> wrote:

> On Sat, Dec 13, 2025 at 1:19 PM David G. Johnston <
> [email protected]> wrote:
>
>> On Saturday, December 13, 2025, Ron Johnson <[email protected]>
>> wrote:
>>>
>>> pg_isready is "ncat -zv $host 5432" for systems which don't have ncat
>>> installed.
>>>
>>
>> Pretty sure this is also an incorrect, or at least incomplete statement.
>>  pg_isready uses the PostgreSQL wire protocol to make a better
>> determination as to readiness than ncat does.  People are just complaining
>> that it doesn’t go further than it does.  They see “user” and “database”
>> and misinterpret why those options exist.
>>
>
> We've had this discussion before: people see the --dbname and --username
> options, then quite reasonably think "ah, those options must mean you can
> test whether a specific database and/or role can connect; otherwise, why
> the heck would you put them in the --help output?"
>
> Bottom line: the purpose of --dbname is to specify a database name; the
> purpose of --username is to specify a username.  Having them in the --help
> output *misleads the user*.
>
>
Yes, here.


https://www.postgresql.org/message-id/flat/CANzqJaCSbqU3QUqMhfv5ivYww%3DJQNwyYnKWnEJoO_onCiCrhSg%40m...

It's unfortunate that the default assumption about those options is
incorrect and one needs to read the notes to understand their purpose.

David J.

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: pgping?
  In-Reply-To: <CAKFQuwa3ZswZJ13BmEtN8mRMfv3EkbUzD8bQOOKs9uBCqF5RDg@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