MIME-Version: 1.0
References: 
 <CAPdrarpx11sa=W2dQhLAhQGQ=2a_wtMmB8KPqEY-C4ZbJem1JA@mail.gmail.com>
 <CANzqJaApzEfVtBqvitzFunaVNpwTDy=rNorXm0_YAuCFVO_c=w@mail.gmail.com>
 <2046739.1758254802@sss.pgh.pa.us>
 <471a0d22-f769-450d-a084-74ece10915d5@netcologne.de>
 <CANzqJaCg=4hPD8Tyn7ohz3hNMQG6=dhVPqEK-5qpnDKpR0W=RQ@mail.gmail.com>
 <CAKFQuwY9iMKOhnf+3Xy+18CmEEKpjNen9F8PE0gjgqPcyd=OuQ@mail.gmail.com>
In-Reply-To: 
 <CAKFQuwY9iMKOhnf+3Xy+18CmEEKpjNen9F8PE0gjgqPcyd=OuQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 13 Dec 2025 17:27:00 -0500
Message-ID: 
 <CANzqJaC=qfACMk4Us4CcP1ryjLWk2YQzLcRrRh34FRG6OVUWpA@mail.gmail.com>
Subject: Re: pgping?
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000106ede0645dce1da"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaC%3DqfACMk4Us4CcP1ryjLWk2YQzLcRrRh34FRG6OVUWpA%40mail.gmail.com>
Precedence: bulk

--000000000000106ede0645dce1da
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sat, Dec 13, 2025 at 1:19=E2=80=AFPM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Saturday, December 13, 2025, Ron Johnson <ronljohnsonjr@gmail.com>
> 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 complainin=
g
> that it doesn=E2=80=99t go further than it does.  They see =E2=80=9Cuser=
=E2=80=9D and =E2=80=9Cdatabase=E2=80=9D
> 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*.

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

--000000000000106ede0645dce1da
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Sat, Dec 13, 2025 at 1:19=E2=80=AFPM D=
avid G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.g.=
johnston@gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quot=
e_container"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Saturday,=
 December 13, 2025, Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.c=
om" target=3D"_blank">ronljohnsonjr@gmail.com</a>&gt; wrote:<blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_quo=
te"><div>pg_isready is &quot;ncat -zv $host 5432&quot; for systems which do=
n&#39;t have ncat installed.=C2=A0</div></div></div></blockquote><div><br><=
/div><div>Pretty sure this is also an incorrect, or at least incomplete sta=
tement. =C2=A0pg_isready uses the PostgreSQL wire protocol to make a better=
 determination as to readiness than ncat does.=C2=A0 People are just compla=
ining that it doesn=E2=80=99t go further than it does.=C2=A0 They see =E2=
=80=9Cuser=E2=80=9D and =E2=80=9Cdatabase=E2=80=9D and misinterpret why tho=
se options exist.</div></blockquote><div><br></div><div>We&#39;ve had this =
discussion before: people see the --dbname and --username options, then qui=
te reasonably think &quot;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?&quot;</div><div><br></div><div>Bottom li=
ne: the purpose of --dbname is to specify a database name; the purpose of -=
-username is to specify a username.=C2=A0 Having them in the --help output =
<b>misleads the user</b>.</div><div><br></div></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t b=
oil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!</div></=
div></div></div></div></div>

--000000000000106ede0645dce1da--