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 1w7TH1-005LjY-0f for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Mar 2026 07:12:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7TGz-008MqH-26 for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Mar 2026 07:12:26 +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.96) (envelope-from ) id 1w7TGz-008Mq9-0y for pgsql-hackers@lists.postgresql.org; Tue, 31 Mar 2026 07:12:25 +0000 Received: from mail-lf1-x136.google.com ([2a00:1450:4864:20::136]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7TGx-0000000286k-0nGn for pgsql-hackers@lists.postgresql.org; Tue, 31 Mar 2026 07:12:25 +0000 Received: by mail-lf1-x136.google.com with SMTP id 2adb3069b0e04-5a159c1e65aso5006730e87.0 for ; Tue, 31 Mar 2026 00:12:23 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774941142; cv=none; d=google.com; s=arc-20240605; b=fxo67g7kMFmO7GbGeVAW0lQiimsSWJOFIm+naf0CFaJaNuoW/j2Gmrg47E8k2uTRLo tSj0u6vxNy/pcfvTmx6mwHVEiPqb/VwliZD6MYzYTJWvQ+cGkqmgVKldF41eukB3IoW9 Mb7Ilm9w50TqKs31FGu6ZfN6WN/hZO+ItRHveGC8+DkgwFx1IaM30TQvaoLF9NGlPfRe 82qnrNZRXesCUwW8xuolPoF3MuCRSUSaQchYuHhBOcvctXdR/HOLlSQD1BU0WnzN2kjq BbeD1DzNgT5ykshVr+79gE34RG3MGEMpDtqhlqPAn4EZblV7IWSfTew0yR18z1eADS4d P9tA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=kknlPb5W1zIvl6rVwpmzM4J25//cAT/mB018fNQQ12Q=; fh=WCTXt89SlAkMBDcSEwsaBvwDnVPaEyrprKHHAmQdnM0=; b=A6lihN2bjhnPIm6b7l4/9iTvD2KuHDFPgClVC+DO/TbVwgw2cjwgI0np/smW1wqLKQ ldgEEsyRrWFBrPpNpg8eOV5zDI53CZMt97d76OO9jIg0pY2U7IAdVuKxoJnxfR9QH387 QVIsBpLi7j+8z+cO6Cybe6M25++HqKiX9vgrLjPzxvZAAV1Ufb63iuJuHW19hr42tjuN DatthXFATKjtoeDdMmjjtNzhQ+EfdocLCfrz1JsnWSgH/tuiknCvtetRtsUF+OgpQzBU wLF90AIBT1Hq1VaA2YA8LhHsg5OG5n338goCwToA89vSJiiXVWH2Bq1oLIo+yZtr+xBy YaVA==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=jeltef.nl; s=google; t=1774941142; x=1775545942; 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=kknlPb5W1zIvl6rVwpmzM4J25//cAT/mB018fNQQ12Q=; b=YKmRvVS9sAq5tpJjhiCZVhdksM9MD2EhvIuU/G9XVM2kRdbN5FyKMDiEy7iEA47FeD AGnjofEYEOTOeK4KmlFI4tsKdF791JaEo2sLIKwuNEjLm44V0J2Sy3vt6MIDh1jYyO85 qBxGCYi5n66fZ4NZmjMjofMN8tIWwxUbtpdhy684Jfolg9zVdZxyX6ary9dZYDJPDgtN 4xFpUMv4GHiq0TTbjQEfCa7NDgvvKxHyU8sqYOPed3g32pviwvTY4J9NKLiJNjgHufsL xwb3sSnVRtUNehy2/WC257LmadaQ2wKqmwNv6r4BM6CYAr11H8i50M5vJmadfUEOYQ2l 3UNA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774941142; x=1775545942; h=cc: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=kknlPb5W1zIvl6rVwpmzM4J25//cAT/mB018fNQQ12Q=; b=UAf4jrC6GpYkjhFdvQ6BOMGakGsBUK3HT6MU77FXM2c9iT1yeJnkONCi/B+cS40AnS XLkXZKeP2iOPc7LjQSZ5P+W1X57S73lRnnku+VfiNKuRtpxLYm7CP/R20IuhJHyyA/Iv KSAai5TTcUSyQ8YjxpMB+otoV8CwXnN8zbRRgHcjY+6WYk3oXRh6sw7iO50WS96Dj8tI vercZBcztzmyFU2jrKAhj7WVMUd7RITTmvJG+aHIuD39HJSGjQ200sh72MvyJFA1XLKd VpQ9uDRN6+favgItNgUqJ09J47Y41NbzzqnyEKXjhNCmg3IOMym9ex7iZL7sHoYHNGnh KipQ== X-Forwarded-Encrypted: i=1; AJvYcCUlBfJOuDTyPbSUEgVVIfwcYycODQH+fpDKmb+RQwlW7U13UkKpgdfqB7q5TvbksXfcRDVRhPPg5GwAjBvI@lists.postgresql.org X-Gm-Message-State: AOJu0Ywm5sVat1zYFB82SEjbQYYyxwpTQ8OqfO4QTKYokRPWElNzdxpZ 62rizuESmc6F13wYOWVbhdkYOjO+PX8cYOG8Aep9QQuPKcuyl0Ug5tuMtDNzD6w3I4Vk+LWKi9n 591bZWH3fmA0/JkQAbaYFF2pIW12ZvqnY54hWVoZnyw== X-Gm-Gg: ATEYQzxS1C4FS4tqgTxC8Gf1Ra/NOCsWv3TS9sn6w2EXCKWbsIWE+PCZJR9qbaz2S9V 3c/qQ7Tx0fagqqveBPaxJ2hP5Bslsx1pLRCVqmtRB+qDgAsFveCbiSfEDZM4q0n1IDDojZSO8Go TFq/7fSQuO7LjhoCzpfuIEDshfoJBBGEpRWTfzSYonTBfCPPXvr5Cl5TUVe8B7kHKyrenwF56AF rNvbTHNYcYaDNjc2+ImGN6LvRn3VlJMtbcEQSu7M+R47qt3MyKW5HiygFc/L2/TXIjD5Gja/1P+ Cy5wjNkW X-Received: by 2002:a05:6512:2255:b0:5a1:1d8c:42a6 with SMTP id 2adb3069b0e04-5a2ab7f03bdmr5556799e87.4.1774941141653; Tue, 31 Mar 2026 00:12:21 -0700 (PDT) MIME-Version: 1.0 References: <20260325.093620.1348358766802101218.ishii@postgresql.org> <20260331.081724.15339448107258985.ishii@postgresql.org> In-Reply-To: <20260331.081724.15339448107258985.ishii@postgresql.org> From: Jelte Fennema-Nio Date: Tue, 31 Mar 2026 09:12:09 +0200 X-Gm-Features: AQROBzA3N1Oqvn0TT--fbQKTQbe06pqzVEzz4gYiKs9S50JS7SlbZIT5DYFYarM Message-ID: Subject: Re: Add GoAway protocol message for graceful but fast server shutdown/switchover To: Tatsuo Ishii Cc: jacob.champion@enterprisedb.com, tomas@vondra.me, zsolt.parragi@percona.com, pgsql-hackers@lists.postgresql.org, davecramer@gmail.com, hlinnaka@iki.fi Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 31 Mar 2026 at 01:17, Tatsuo Ishii wrote: > Interesting. In Pgpool-II case, client disconnection is not a problem, > the connection to PostgreSQL is kept open anyway (if connection > expiration is not set). Probably this is because Pgpool-II only > supports "session level" connection pooling. I guess, I was not clear. Because the same problem exists for Pgpool-II. When pgpool forwards the message to the client, the client will disconnect from pgpool. But if connection_life_time is not reached (and by default this is unlimited) pgpool will not disconnect from the postgres server. So the postgres server has not actually achieved the intended goal, but the client still disconnected for no benefit, only downsides. Maybe the problem is not too bad, i.e. it will cause some unnecessary disconnects from the client, but it shouldn't cause big problems. So maybe the ParameterStatus approach is worth exploring again (I remember I ran into some problems, due to us normally only sending ParameterStatus at the end of a query, but I'm pretty sure that can be worked around somehow).