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.94.2) (envelope-from ) id 1v7muy-007oIE-RF for pgsql-general@arkaria.postgresql.org; Sun, 12 Oct 2025 03:38:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v7muw-000Jmu-Df for pgsql-general@arkaria.postgresql.org; Sun, 12 Oct 2025 03:38:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v7muw-000Jmk-31 for pgsql-general@lists.postgresql.org; Sun, 12 Oct 2025 03:38:43 +0000 Received: from mail-ot1-x32d.google.com ([2607:f8b0:4864:20::32d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v7mut-001gqN-0H for pgsql-general@postgresql.org; Sun, 12 Oct 2025 03:38:42 +0000 Received: by mail-ot1-x32d.google.com with SMTP id 46e09a7af769-7827025e548so1388389a34.2 for ; Sat, 11 Oct 2025 20:38:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760240317; x=1760845117; darn=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=e9Xz90FMdZjaGwjr/rnP+vxTLRSDrAs26S+OiFKpAMg=; b=nQyhMKQ8o/+re8dSU8qWCj1/3XGTENRMykfj0g7Kxw7mAd1jTox6kQqeubl2/dmUy8 6VHNfoLH1nNGlIQquK9cuzKt9IVce3Rcud1Hy9NTuZphgnEJcRWuVnb0uQ3n1+gkN1og TAI+HOTFnt4PdpsBE+6jks1QgJGI/Vt0xmS5leGM7aTodn/Y/0UDfzisDIG3xrxhUEmG z3DeDwijmvhsVMbvM0OBwdo+bHCJnNUBPRh747qi9i2RRD3VGfjqo1lPyKHbyYe6WRR2 MrWb9yZlcfvedZnVzs6hV4JE04QTStX0/wnRW1soaPTALOyR0d1E4dOD1GkEVCD66YSB Fidw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760240317; x=1760845117; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=e9Xz90FMdZjaGwjr/rnP+vxTLRSDrAs26S+OiFKpAMg=; b=Hie1df5tV7QzDGQOddsT2m9OxDmkG5WJRJUNsiKRYwpxUBQ6YS0sioVzt3J8QNAFE4 qKB97UL8bxSwMi9iziMhhYJ6OKsMNcvtHGGWyLkpmHIRz+3whO0wtoXNuOCs1RZH8VCC JLD71dDfFZQ1iGdwBeXkrX7x1uVPQ/QbLVj/082/XLf/kAX9D//iGQHJ+xo3FYTNkFbs ZxE1yMJ5ulb0VDX3TVdWcARWFpyCuWFdf2FKwkVUHVGLoQTxJ7jli9WbzYrMval9PP5L mKk5k3eueEW7ub4BiSEXT2dF409f+KyIugijBQGH47OEQmphmLB7JIkffUglrHQyp+MR 697w== X-Gm-Message-State: AOJu0YwWV4F4HeBff0JaMumMNCMGFcYNJYgPIynEc/7ZL8Pv//R50oYO gx5hGPiKDnlUQp1fKrtldKqcYAUcTQmNVTPi3zwa0mSf4zifa0BsfkC/egSh0y2Be0+RHl3mSU8 Nd57on8tJ2JdDpXnv6v2BpTxwD+S+QLxWtw== X-Gm-Gg: ASbGnctZkIpXorakktgcxQr5LGd9gNb3SJBTuCPQC3uWpHgQs3dfEJslb3e1RhTbdvz pzXFx51ILn2nCUwFbNwP7+MQRA6hwwyqivrASwdo0GszNf3L8080RT5mODP82duNON52XFWuZ7U MOjwGQC/sEtU5mniS/tAfaXhz8AXAJ8b7B8h9febt5nOK+bP5N8aXjBYedueEj5T95oqOGSSZvZ 1OT9JeCafTIWdN8GvgXj3LiJjCpMN9GNS1bCA== X-Google-Smtp-Source: AGHT+IFPRdqs5z8pQVN90xd0u5KBGsZph0ozVIg0NLDN//GzYowXjrmz7ar776YtsODH/yhjJ104hfeTihOiIrhbyfw= X-Received: by 2002:a05:6870:a54a:b0:35b:7d80:b175 with SMTP id 586e51a60fabf-3c0f81feda8mr6716399fac.44.1760240316646; Sat, 11 Oct 2025 20:38:36 -0700 (PDT) MIME-Version: 1.0 References: <15c40010-da97-4a87-9eab-8c23a72c0816@aklaver.com> In-Reply-To: <15c40010-da97-4a87-9eab-8c23a72c0816@aklaver.com> From: Ron Johnson Date: Sat, 11 Oct 2025 23:38:25 -0400 X-Gm-Features: AS18NWDJcVa819zi9ZoQRlFdJ0M_y2mlrzslx7Htj1BAzYMVwZ5VflTotBHrIIU Message-ID: Subject: Re: Option on `postgres` CLI to shutdown when there are no more active connections? To: pgsql-general Content-Type: multipart/alternative; boundary="000000000000cb0a6b0640ede29b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000cb0a6b0640ede29b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, Oct 11, 2025 at 11:21=E2=80=AFPM Adrian Klaver wrote: > On 10/11/25 19:56, Ron Johnson wrote: > > On Sat, Oct 11, 2025 at 7:11=E2=80=AFPM Adrian Klaver > > wrote: > > > > > I think OP is looking for AUTO_CLOSE, like SQL Server (and Rdb/VMS > > before it). Its only real utility is OP's use-case: a Windows > > desktop running local testing. > > From the original post: > > "Is there any interest in adding a command line option to the `postgres` > CLI" > > Which I took to mean: > > https://www.postgresql.org/docs/current/app-postgres.html Yeah. Something like this, which we don't have: postgres -c "auto_close=3Don" --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000cb0a6b0640ede29b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sat, Oct 11, 2025 at 11:21=E2=80=AFPM = Adrian Klaver <adrian.klave= r@aklaver.com> wrote:
On 10/11/25 19:56= , Ron Johnson wrote:
> On Sat, Oct 11, 2025 at 7:11=E2=80=AFPM Adrian Klaver <adrian.klaver@aklaver.co= m
> <mailto:adrian.klaver@aklaver.com>> wrote:
>

> I think OP is looking for AUTO_CLOSE, like SQL Server (and Rdb/VMS > before it).=C2=A0 Its only real utility is OP's use-case: a Window= s
> desktop=C2=A0running local testing.

=C2=A0From the original post:

"Is there any interest in adding a command line option to the `postgre= s`
CLI"

Which I took to mean:

https://www.postgresql.org/docs/current/a= pp-postgres.html

Yeah.= =C2=A0 Something like this, which we don't have:
postgres -c = "auto_close=3Don"

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