Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vNZoQ-0075ag-21 for pgsql-admin@arkaria.postgresql.org; Mon, 24 Nov 2025 16:53:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vNZoO-002Ct2-2V for pgsql-admin@arkaria.postgresql.org; Mon, 24 Nov 2025 16:53:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vNZoO-002Cst-1F for pgsql-admin@lists.postgresql.org; Mon, 24 Nov 2025 16:53:12 +0000 Received: from mail-oa1-x2b.google.com ([2001:4860:4864:20::2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vNZoM-001EdX-0p for pgsql-admin@lists.postgresql.org; Mon, 24 Nov 2025 16:53:11 +0000 Received: by mail-oa1-x2b.google.com with SMTP id 586e51a60fabf-3eae4e590a4so1554959fac.1 for ; Mon, 24 Nov 2025 08:53:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1764003190; x=1764607990; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=QDzv6FZdDtsj5oEJMyTvwJseu0VtNjrcoFWAIkLPLjQ=; b=YZxW8Jgt45xknwEkTXrKbCFupasCyn9hPHFfsw8s68IlssrF7HWJ2hG80IAiCi53HF iNyryiMcwIPlMYyjpvf0yRMI8qp0gTswsS7sL/oy6CAwyIlYWyXiEXeo2moxi8hlidXz lV6n7A6bTX4YUpktqYTX92c5KRtMis4GB2s6oH+YR5qcbnPNCr/PYPO5QkJlISGtWBxb wkls/Sp2QVqpWB3luWWglOOt2zs/z7ItLQ+aJHvH5ZddC8Q7r/UBAZKYESFR4gnM3qN+ ImLi45xQK/ZRXJJV6TS1Rk1BuGBU2u6tG58Ps8MzDysSr6OPKMlP4tgaUjmHPXqF+YzI 0sFw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764003190; x=1764607990; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-gg:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=QDzv6FZdDtsj5oEJMyTvwJseu0VtNjrcoFWAIkLPLjQ=; b=N5UrCNKthAqxGRCWqWlG+23Ea+5OUuqn9pVn0U6zmWgsS9yQKlk3VHig4IQJGNOqzB /huMbp3ZEkZDabePJUEPnQazxhQTI88iAA+ptxXga+nJLqstatuDGcJZ1dBd3uQaoebQ xA7fTJzIaV2g+TClNUpT0NptkmmGpeS+ArB4ajlAVjDFbGA1Z8GjDp1iMfR5Oh5ndXCv RMBPy7DUIGsRc9dTreH1V+fjvpS2jd8h9rKNr7E9V5RediG+RPCdmMXS+yMaH7Dn4T/H R+nsNXkXq9Ii+aQOd3QA0CMIkhxqWcLPBZR8DHIGsfP5LcEz6qcte2xqJC6uziPDUBMo Kd7A== X-Gm-Message-State: AOJu0Yzixz4VJDMc7vPUslExXOtcsSTedsj+Y9vfi/AiMlUtAQR49c7M 1iEyPTCsVCFfpNlLkwglAcIl71AG8g1TVyPHf+UVS9IX6xZM7FG7ZPNvnbmX2dhycP5ap3lfYEi gBiBlqdBEQ7iokhbZN3vHQ4FL0vjLO8qqTQ== X-Gm-Gg: ASbGncsNpMaHDwmRB6f9ahlyUxhCZaQQFuIVs6J6/cqiInYCCy0We36XVBc3Gg48XcW TbJsecQzfrFR8M0hhS3xlyHwTOaDZonT+vQRSx+hMXtivdkm4xBKwKUFC1++AX9qdUO5KwGJTN3 H4MI77Jhu2Voq6DJnCY0A51LtaG0Q2K9Ua716RMBfZvTnzNbK61RQ7MktlBNMqsu/qH0E+34d/p c4DWJhyzNYQbnTIMTg6GQcCV3Y1TgWbBdILk7ubykvS0CRspHfurCJsJi33vwcMZvrY9fXS X-Google-Smtp-Source: AGHT+IGeutQh3FqoTB7pLUsHlPA+5ZXZzohlfIL3byn+HjmITrLuE/LfGK8RNOGZRzkMFUf8rQdqdZo1vEr7UEEk/g8= X-Received: by 2002:a05:6808:1491:b0:450:c9ad:491b with SMTP id 5614622812f47-4511572eb09mr4500871b6e.8.1764003190151; Mon, 24 Nov 2025 08:53:10 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 24 Nov 2025 11:52:58 -0500 X-Gm-Features: AWmQ_blWoszonYiFBrlTCRdslktEWVW-8lvus3bDVNYOQeJQNtNWedSWR9UNvZ8 Message-ID: Subject: Re: Is the pg_isready database name relevant? To: Pgsql-admin Content-Type: multipart/alternative; boundary="000000000000881f21064459ff8f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000881f21064459ff8f Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Nov 24, 2025 at 11:45=E2=80=AFAM David G. Johnston < david.g.johnston@gmail.com> wrote: > On Monday, November 24, 2025, Ron Johnson wrote= : > >> On Mon, Nov 24, 2025 at 11:30=E2=80=AFAM David G. Johnston < >> david.g.johnston@gmail.com> wrote: >> >>> On Monday, November 24, 2025, Ron Johnson >>> wrote: >>> >>>> The "-d, --dbname=3DDBNAME" 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=E2=80=99s 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. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000881f21064459ff8f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Nov 24, 2025 at 11:45=E2=80=AFAM = David G. Johnston <david.g= .johnston@gmail.com> wrote:
On Monday, = November 24, 2025, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
On = Mon, Nov 24, 2025 at 11:30=E2=80=AFAM David G. Johnston <david.g.johnston@gmail.com= > wrote:
On Monday, November 24, 2025, Ron Johnson <ronljohnsonjr@gmail.= com> wrote:
The "-d, --dbname=3DDBNAME" option is mentione= d in --help output, but pg_isready ignores=C2=A0nonexistent=C2=A0databases.=

Is this an application bug, a minor doc bug or am= I=C2=A0missing something?

= It=E2=80=99s documented in the Notes section.

That seems odd.=C2=A0 Why mention an option in --help if the optio= n isn't needed?

Becau= se it exists - and I figure most people should use it to not put spurious e= rrors 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=C2=A0be fixed.=C2=A0 Very low priority, after the data corrup= tion and feature bugs, and useful new=C2=A0features added, but either retur= n 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!
--000000000000881f21064459ff8f--