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>
In-Reply-To: <471a0d22-f769-450d-a084-74ece10915d5@netcologne.de>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 13 Dec 2025 12:12:04 -0500
Message-ID: 
 <CANzqJaCg=4hPD8Tyn7ohz3hNMQG6=dhVPqEK-5qpnDKpR0W=RQ@mail.gmail.com>
Subject: Re: pgping?
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c2ae0e0645d87a5f"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaCg%3D4hPD8Tyn7ohz3hNMQG6%3DdhVPqEK-5qpnDKpR0W%3DRQ%40mail.gmail.com>
Precedence: bulk

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

On Sat, Dec 13, 2025 at 8:20=E2=80=AFAM Gunnar <tongji@netcologne.de> wrote=
:

>
>
> On 9/19/25 06:06, Tom Lane wrote:
> > Ron Johnson <ronljohnsonjr@gmail.com> writes:
> >> On Thu, Sep 18, 2025 at 4:47=E2=80=AFPM Ron Watkins <rwatki@gmail.com>=
 wrote:
> >>> How do you install pgping on RHEL 9?
> >>> It doesn't appear to come with the distribution.
> >>> Is there some specific repo you need to use?
> >> What does it do that ncat and psql don't do?
> > pg_isready might be what the OP wants.
> >
> >                       regards, tom lane
> my latest experience with pg_isready reminded me that it only works on a
> general level (cluster ready generally) though.
> If you include a database to the command it still reports true even if
> the database you want to address does not exist.
>
> That said I remember that I read this was broken since ... forever,
> which means nobody cares.
>

pg_isready is "ncat -zv $host 5432" for systems which don't have ncat
installed.  No/few Linux systems meet that criterion, but Windows systems
might.

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

--000000000000c2ae0e0645d87a5f
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 8:20=E2=80=AFAM G=
unnar &lt;<a href=3D"mailto:tongji@netcologne.de">tongji@netcologne.de</a>&=
gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex"><br>
<br>
On 9/19/25 06:06, Tom Lane wrote:<br>
&gt; Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com" target=3D"_=
blank">ronljohnsonjr@gmail.com</a>&gt; writes:<br>
&gt;&gt; On Thu, Sep 18, 2025 at 4:47=E2=80=AFPM Ron Watkins &lt;<a href=3D=
"mailto:rwatki@gmail.com" target=3D"_blank">rwatki@gmail.com</a>&gt; wrote:=
<br>
&gt;&gt;&gt; How do you install pgping on RHEL 9?<br>
&gt;&gt;&gt; It doesn&#39;t appear to come with the distribution.<br>
&gt;&gt;&gt; Is there some specific repo you need to use?<br>
&gt;&gt; What does it do that ncat and psql don&#39;t do?<br>
&gt; pg_isready might be what the OP wants.<br>
&gt;<br>
&gt;=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0regards, tom lane<br>
my latest experience with pg_isready reminded me that it only works on a <b=
r>
general level (cluster ready generally) though.<br>
If you include a database to the command it still reports true even if <br>
the database you want to address does not exist.<br>
<br>
That said I remember that I read this was broken since ... forever, <br>
which means nobody cares.<br></blockquote><div><br></div><div>pg_isready is=
 &quot;ncat -zv $host 5432&quot; for systems which don&#39;t have ncat inst=
alled.=C2=A0 No/few Linux systems meet that criterion, but Windows systems =
might.</div></div><div><br></div><span class=3D"gmail_signature_prefix">-- =
</span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Deat=
h to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m sti=
ll alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></d=
iv></div>

--000000000000c2ae0e0645d87a5f--