MIME-Version: 1.0
In-Reply-To: <6678e492-b544-4ad3-bd79-2dd3ff3cefaa@netcologne.de>
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>
 <CAKFQuwbr_uyCZSdtF0huf+5FM2CBXWmZGkjLOu1721Wejj6BRA@mail.gmail.com>
 <6678e492-b544-4ad3-bd79-2dd3ff3cefaa@netcologne.de>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sun, 14 Dec 2025 05:54:12 -0700
Message-ID: 
 <CAKFQuwayahduJa8VaYffsq2Ask7aEqs=QehhN8s6xs+ehLk7eQ@mail.gmail.com>
Subject: Re: pgping?
To: Gunnar <tongji@netcologne.de>
Cc: "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d012390645e8fdec"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwayahduJa8VaYffsq2Ask7aEqs%3DQehhN8s6xs%2BehLk7eQ%40mail.gmail.com>
Precedence: bulk

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

On Saturday, December 13, 2025, Gunnar <tongji@netcologne.de> wrote:

>
>
> On 12/13/25 15:54, David G. Johnston wrote:
>
>
>
> On Friday, December 12, 2025, Gunnar <tongji@netcologne.de> wrote:
>
>>
>> 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, whic=
h
>> means nobody cares.
>>
>>
> It isn=E2=80=99t broken - it is working precisely as intended and require=
d for the
> use cases it=E2=80=99s meant to solve.  That=E2=80=99s why no one is fixi=
ng it.  These
> people that want it to solve additional use cases need to step up and
> implement some new features for it.
>
>
> hm, one might argue, that if the use case 'pg_isready -d database' is
> mentioned in the manual this could be seen as the aspiration, or maybe ev=
en
> commitment to that feature.
> Even the description of pg_isready --help mentions a "connection check to
> a database", not a cluster.
>
> Do I misinterpret the manual/help? If that was the case my next question
> was ... what is the purpose of the option -d, --dbname=3DDBNAME ?
>

As I wrote in the other thread while rephrasing what the docs say: it
avoids an inconsequential error message in the server log since the backend
protocol requires any connection attempt to include those fields and
sometime the defaults aren=E2=80=99t correct.

David J,

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

<br><br>On Saturday, December 13, 2025, Gunnar &lt;<a href=3D"mailto:tongji=
@netcologne.de">tongji@netcologne.de</a>&gt; wrote:<br><blockquote class=3D=
"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding=
-left:1ex"><u></u>

 =20
   =20
 =20
  <div>
    <br>
    <br>
    <div>On 12/13/25 15:54, David G. Johnston
      wrote:<br>
    </div>
    <blockquote type=3D"cite">
     =20
      <br>
      <br>
      On Friday, December 12, 2025, Gunnar &lt;<a href=3D"mailto:tongji@net=
cologne.de" target=3D"_blank">tongji@netcologne.de</a>&gt;
      wrote:<br>
      <blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-l=
eft:1px #ccc solid;padding-left:1ex"><br>
        my latest experience with pg_isready reminded me that it only
        works on a general level (cluster ready generally) though.<br>
        If you include a database to the command it still reports true
        even if the database you want to address does not exist.<br>
        <br>
        That said I remember that I read this was broken since ...
        forever, which means nobody cares.<br>
        <br>
      </blockquote>
      <div><br>
      </div>
      <div>It isn=E2=80=99t broken - it is working precisely as intended an=
d
        required for the use cases it=E2=80=99s meant to solve.=C2=A0 That=
=E2=80=99s why no
        one is fixing it.=C2=A0 These people that want it to solve addition=
al
        use cases need to step up and implement some new features for
        it.</div>
    </blockquote>
    <br>
    hm, one might argue, that if the use case &#39;pg_isready -d database&#=
39;
    is mentioned in the manual this could be seen as the aspiration, or
    maybe even commitment to that feature.<br>
    Even the description of pg_isready --help mentions a &quot;connection
    check to a database&quot;, not a cluster.<br>
    <br>
    Do I misinterpret the manual/help? If that was the case my next
    question was ... what is the purpose of the option -d,
    --dbname=3DDBNAME ?</div></blockquote><div><br></div><div>As I wrote in=
 the other thread while rephrasing what the docs say: it avoids an inconseq=
uential error message in the server log since the backend protocol requires=
 any connection attempt to include those fields and sometime the defaults a=
ren=E2=80=99t correct.</div><div><br></div><div>David J,</div><div>=C2=A0</=
div>

--000000000000d012390645e8fdec--