MIME-Version: 1.0
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>
In-Reply-To: <CAFCRh-94eXetAjtCURs5F0JZQr=kso0rVgVSEmWiSD7wA6VcMw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 13 Oct 2025 11:07:53 -0400
Message-ID: <CANzqJaDn_mVi4M0CbKnVNwK9RxYOneoCRmd_d69rbjBrwasuPQ@mail.gmail.com>
Subject: Re: Option on `postgres` CLI to shutdown when there are no more
 active connections?
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000005eea0206410ba2e7"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDn_mVi4M0CbKnVNwK9RxYOneoCRmd_d69rbjBrwasuPQ%40mail.gmail.com>
Precedence: bulk

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

On Mon, Oct 13, 2025 at 4:47=E2=80=AFAM Dominique Devienne <ddevienne@gmail=
.com>
wrote:
[snip]

> There's apparently no way to abstract the "transport" between libpq
> and the server, must be TCP (or *nix only socket files), cannot be an
> in-memory channel (for the embedded non-shared case),
>

I'd bet a nickel that local socket transfers all stay in memory.


> nor shared-memory (for the shared-case across localhost processes).
>

Shared memory means that I can stomp all over you, and you can't stop me.
That's the antithesis of ACID.

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Oct 13, 2025 at 4:47=E2=80=AFAM D=
ominique Devienne &lt;<a href=3D"mailto:ddevienne@gmail.com">ddevienne@gmai=
l.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container">=
<div>[snip]=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0p=
x 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
There&#39;s apparently no way to abstract the &quot;transport&quot; between=
 libpq<br>
and the server, must be TCP (or *nix only socket files), cannot be an<br>
in-memory channel (for the embedded non-shared case),<br></blockquote><div>=
<br></div><div>I&#39;d bet a nickel that local socket transfers all stay in=
 memory.</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"m=
argin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left=
:1ex">
nor shared-memory (for the shared-case across localhost processes).<br></bl=
ockquote><div></div></div><div><br></div><div>Shared memory means that I ca=
n stomp all over you, and you can&#39;t stop me.=C2=A0 That&#39;s the antit=
hesis of ACID.</div><div><br></div><span class=3D"gmail_signature_prefix">-=
- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">De=
ath to &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m s=
till alive.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div><=
/div></div>

--0000000000005eea0206410ba2e7--