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 1v9WJs-001qtk-K3 for pgsql-general@arkaria.postgresql.org; Thu, 16 Oct 2025 22:19:35 +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 1v9WJr-00Fy5S-J6 for pgsql-general@arkaria.postgresql.org; Thu, 16 Oct 2025 22:19:34 +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.94.2) (envelope-from ) id 1v9WJr-00Fy5J-8Y for pgsql-general@lists.postgresql.org; Thu, 16 Oct 2025 22:19:34 +0000 Received: from mail-il1-x12c.google.com ([2607:f8b0:4864:20::12c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v9WJo-002Aj6-2H for pgsql-general@lists.postgresql.org; Thu, 16 Oct 2025 22:19:33 +0000 Received: by mail-il1-x12c.google.com with SMTP id e9e14a558f8ab-424da17e309so13602905ab.2 for ; Thu, 16 Oct 2025 15:19:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760653171; x=1761257971; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=h8bcEoNcAfvQMMaykUZ7W3gocqEj9C8cX4dFS4PrwZA=; b=G+1d3604ty2EAG7MhTuB9+RwPhg2qG992tEcIyWX/11fXMz2GjjZjAyEnV1XIW7BP7 q4yKNKjZSlX032CAz9V10phHqhK1rRl7xkGNxY/70G0SWditkJbo2hZv5q/ffQFCDIko 0C+BVMbjgbXCcF87alvcd98KSE61que6uLL0c7L1WBDe0DKA7CbZJTDHWuGQLtp1q0FH dy80u5DXyeo+P5NCvSmHzyzfBvC8MwK8xrmKwOFtkOTz+gfrFPdFksObn9QWrnrUVHR6 F3tx5bBQIjD5KNpPNiMtuFrjmL4YB/i7msflMXS//humr2ugSY58WihwTs7ycsu1+Kc1 Sg+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760653171; x=1761257971; h=cc: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=h8bcEoNcAfvQMMaykUZ7W3gocqEj9C8cX4dFS4PrwZA=; b=tY3Jxng0t9kXg85LxhxAczWPFw/iFw8UBChqSC4/E3/FYD7T4bICPRknonyen80ktA uwSmCjGYQ0aW/QkD1QEt01UOk7qDyHt+oW4jn3Wk98qssHH/V96ZQuzyTTWjPyw5znxF l0dPAogoXTKv+w8IRob0h716VKlR9B2kRLs5KQy4ypkfY3c0+XzrQFgNlfpZU8J/Y7mO DIbY8pX7yKTx2DtZrSknVMxVmiYlqf3QxMIQOJWSaF8mNrUFxGAMcXhNQqVSpgGuUPAl qwUZqs9DCcUGaQZJa7qRHCGRYvQP9S8pKCTIwZTJbzc+6UQHu/CVTcXGiwlyQFa0njtK UQjA== X-Forwarded-Encrypted: i=1; AJvYcCUzDVh3ssj10Rtq3rnV4fsORohVhhG7vnVpsoNH43x2Ligv+P3TJD8nDhtpN1ENpnfNtC0GzNn8jVLfMXI9@lists.postgresql.org X-Gm-Message-State: AOJu0YyqbikMP0+dzusVLcYcBwsChHpBUUrIONRjmMyN0bOK/Q+yMhLz WEu7ChPvE2wGxWTBTSp3xKj9sBPYcjPG9XKPVcyjbdHwVItPxKYo24Sg7UtDposOXtd0QnD/4JK yzzmMDdKR/5Uw4TF8P5KkLofus3YCzwk= X-Gm-Gg: ASbGncu80fP0mFch+nk5fRijjVU1iiViczxT6NMQgx3YNUcnMsXOfSUDUKh0sjrhg/b 3dlgFDyr+bGs0T7XZxvKxVZqxxo5O1+796fH7z8D+A1SLcuEJVDV6FSi8IRnZ9oCyODYN5Dkwg+ nqfJ9y1jz13M9tY5Ct/nwGOxwVRXU7syNVZEGIRM7LunExjgA/ppYnwp886Eh/PHMhab686fbLM Hb6iX+TzNGivDc8Q11Y7haT459rt9k3okxjQpjz6GVDfQKEVLzK2ekIhlU7W3/KGdhfqnPE6vYS OS1/JbfZNhFdFAoUkYjZ15+XbVCBbA== X-Google-Smtp-Source: AGHT+IFcwm38RCvkmLnp0sEJt5QvYtkhf/Ar2tKeupP9sy+sJkNX+SSe4COH5CyQsr6RIeiAD7nL0dIIQf4LeL+bJvM= X-Received: by 2002:a92:c265:0:b0:430:af8f:1d28 with SMTP id e9e14a558f8ab-430c5223e4cmr33546715ab.11.1760653171485; Thu, 16 Oct 2025 15:19:31 -0700 (PDT) MIME-Version: 1.0 References: <73ff46d2-0bad-4a8d-9928-e494c2d5b0d1@gmail.com> <93702.1760321769@sss.pgh.pa.us> <233155.1760369829@sss.pgh.pa.us> In-Reply-To: From: Greg Sabino Mullane Date: Thu, 16 Oct 2025 18:18:57 -0400 X-Gm-Features: AS18NWCcse8v0sdMcUgDNmN-ueMdNhYmae9PLuoC4nLgNwVwb4p1LoK830C6DlE Message-ID: Subject: Re: Option on `postgres` CLI to shutdown when there are no more active connections? To: David Barsky Cc: Dominique Devienne , Ron Johnson , "pgsql-generallists.postgresql.org" , Tom Lane Content-Type: multipart/alternative; boundary="000000000000dbeeb106414e022e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000dbeeb106414e022e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Oct 13, 2025 at 3:19=E2=80=AFPM David Barsky w= rote: > Anyways, I'll try to get at what motivated this whole discussion: would > there be community opposition to adding a CLI flag that'd exit/shutdown a= ll > Postgres > processes once all pending connections close? > I don't know about opposition, per se, but the onus is on you to provide a strong use case not already covered by existing tools. I don't think that bar has been met yet. -- Cheers, Greg -- Crunchy Data - https://www.crunchydata.com Enterprise Postgres Software Products & Tech Support --000000000000dbeeb106414e022e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable