Date: Wed, 15 Oct 2025 02:42:01 +0000
From: Bird <birdsite@airmail.cc>
To: pgsql-general@lists.postgresql.org, David Barsky <me@davidbarsky.com>,
 Ron Johnson <ronljohnsonjr@gmail.com>
CC: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: =?US-ASCII?Q?Re=3A_Option_on_=60postgres=60_CLI_to_shutdown_?=
 =?US-ASCII?Q?when_there_are_no_more_active_connections=3F?=
In-Reply-To: <CAPR5_5rvpF+vVnexG6CRoN6DNhM3RReQvuHNJC04OpgVujOArg@mail.gmail.com>
References: <CAPR5_5psNqCm1OQr5LL4v6z02Sh=2YHYUg8NY+3xMzfGHfKs+w@mail.gmail.com> <ea93ff28-4496-4e3d-a529-191582e02344@aklaver.com> <CAPR5_5q2oCkw19rHb7oy-M0M0purWFM5Jc8ub5xDy_NdhUmRTw@mail.gmail.com> <73ff46d2-0bad-4a8d-9928-e494c2d5b0d1@gmail.com> <93702.1760321769@sss.pgh.pa.us> <CAFCRh-94eXetAjtCURs5F0JZQr=kso0rVgVSEmWiSD7wA6VcMw@mail.gmail.com> <CANzqJaDn_mVi4M0CbKnVNwK9RxYOneoCRmd_d69rbjBrwasuPQ@mail.gmail.com> <CAFCRh--P93bF0gpkdvg4MzMNqq5gK=4eWFkmBDR0xw9dmFVAPQ@mail.gmail.com> <233155.1760369829@sss.pgh.pa.us> <CAFCRh--_14QR1_=vZvKVZkcA_1LRO-pQd2p6BBRMreyAv2_z6w@mail.gmail.com> <CAPR5_5rRYkM9bO=KC_PY-Bj2Fw=t+maEYG+Am-UgaCHRTWyFsg@mail.gmail.com> <CANzqJaBepwWOdD3dOJPMx8KdHaA3xMk8NA9ST5oCK2HUoyqvig@mail.gmail.com> <CAPR5_5rvpF+vVnexG6CRoN6DNhM3RReQvuHNJC04OpgVujOArg@mail.gmail.com>
Message-ID: <49F80E9B-C91F-4352-912B-DD39C84BBAD7@airmail.cc>
MIME-Version: 1.0
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/49F80E9B-C91F-4352-912B-DD39C84BBAD7%40airmail.cc>
Precedence: bulk


On October 14, 2025 9:40:45 PM UTC, David Barsky <me@davidbarsky=2Ecom> wr=
ote:
>> If testing is all scripted, then why not put "pg_ctl stop" at the end o=
f
>the script?
>
>Sorry for the delay=2E
>
>It=E2=80=99s _mostly_ scripted, but two major reasons:
>
>1=2E If that script is cancelled or interrupted for any reason, it=E2=80=
=99s possible
>that
>   `pg_ctl stop` won't be called and I'd have a leaked process=2E

bash has EXIT trap you can use to run functions even in the case of interr=
upts; You can create a wrapper script if its not written in bash=2E

 I could
>mitigate
>   this by calling `pg_ctl stop` at the *start* of the script, but that
>adds a
>   bit of latency I'd prefer to avoid=2E

You could also run pg_ctl stop in the background (i=2Ee=2E in another proc=
ess)=2E Again, if using bash, you just add & at the end=2E It should be pos=
sible to create processes in any scripting language=2E