MIME-Version: 1.0
References: <DDPQ1RV5FE9U.I2WW34NGRD8Z@jeltef.nl>
 <CALdSSPiORRiJ892J07tT3_xcAm=O9JCW-qHUQvFc6axHoDW_Og@mail.gmail.com>
 <DDQJ6HE66UVK.3E1XVYZIVCID8@jeltef.nl>
In-Reply-To: <DDQJ6HE66UVK.3E1XVYZIVCID8@jeltef.nl>
From: Ajit Awekar <ajitpostgres@gmail.com>
Date: Mon, 1 Dec 2025 10:35:19 +0530
Message-ID: 
 <CAER375Nugod9uuowwEUAai9PpoXP2xD-G54MW6hhjQw-6LtSLQ@mail.gmail.com>
Subject: Re: Add GoAway protocol message for graceful but fast server
 shutdown/switchover
To: Jelte Fennema-Nio <postgres@jeltef.nl>
Cc: Kirill Reshke <reshkekirill@gmail.com>, Jelte Fennema-Nio <me@jeltef.nl>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
 Dave Cramer <davecramer@gmail.com>,
	Jacob Champion <jacob.champion@enterprisedb.com>,
 Heikki Linnakangas <hlinnaka@iki.fi>
Content-Type: multipart/alternative; boundary="0000000000009d3c530644dced49"
Archived-At: 
 <https://www.postgresql.org/message-id/CAER375Nugod9uuowwEUAai9PpoXP2xD-G54MW6hhjQw-6LtSLQ%40mail.gmail.com>
Precedence: bulk

--0000000000009d3c530644dced49
Content-Type: text/plain; charset="UTF-8"

Hi Jelte,

Thank you for proposing the GoAway protocol message.

I've developed a patch that serves as a strong, immediate use case for its
inclusion.
https://www.postgresql.org/message-id/flat/CAER375OvH3_ONmc-SgUFpA6gv_d6eNj2KdZktzo-f_uqNwwWNw%40mail.gmail.com


Thanks & Best Regards,

Ajit


On Fri, 24 Oct 2025 at 17:24, Jelte Fennema-Nio <postgres@jeltef.nl> wrote:

> On Fri Oct 24, 2025 at 7:04 AM CEST, Kirill Reshke wrote:
> > On Thu, 23 Oct 2025 at 18:05, Jelte Fennema-Nio <me@jeltef.nl> wrote:
> > Im +1 on this idea. This is something I wanted back in 2020, when
> > implementing the 'online restart' feature for odyssey[0], but never
> > bothered to create a thread.
>
> Yeah, to be clear: A big goal of this is definitely to be used by
> poolers/proxies/middleware. Those systems will often be more frequently
> restarted than the actual database servers, so being able to do that
> quickly without disrupting active connections is much more important
> there than with plain PostgreSQL servers.
>
> > About patches:
>
> Thanks for the review. Attached is a new patchset. I think I addressed
> all of your comments (I almost fully rewrote the docs). I also fixed
> two other issues that I found:
> - updating docs for 3.3 in more places
> - handling the GoAway message in more code paths on the client side
>
>

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

<div dir=3D"ltr">Hi Jelte,<div><br></div><div><p>Thank you for proposing th=
e <code>GoAway</code> protocol message.=C2=A0</p><p>I&#39;ve developed a pa=
tch that serves as a strong, immediate use case for its inclusion.=C2=A0<a =
href=3D"https://www.postgresql.org/message-id/flat/CAER375OvH3_ONmc-SgUFpA6=
gv_d6eNj2KdZktzo-f_uqNwwWNw%40mail.gmail.com">https://www.postgresql.org/me=
ssage-id/flat/CAER375OvH3_ONmc-SgUFpA6gv_d6eNj2KdZktzo-f_uqNwwWNw%40mail.gm=
ail.com</a></p><p><br></p><p>Thanks &amp; Best Regards,</p><p>Ajit</p><p></=
p></div></div><br><div class=3D"gmail_quote gmail_quote_container"><div dir=
=3D"ltr" class=3D"gmail_attr">On Fri, 24 Oct 2025 at 17:24, Jelte Fennema-N=
io &lt;<a href=3D"mailto:postgres@jeltef.nl">postgres@jeltef.nl</a>&gt; wro=
te:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Fri Oct 2=
4, 2025 at 7:04 AM CEST, Kirill Reshke wrote:<br>
&gt; On Thu, 23 Oct 2025 at 18:05, Jelte Fennema-Nio &lt;<a href=3D"mailto:=
me@jeltef.nl" target=3D"_blank">me@jeltef.nl</a>&gt; wrote:<br>
&gt; Im +1 on this idea. This is something I wanted back in 2020, when<br>
&gt; implementing the &#39;online restart&#39; feature for odyssey[0], but =
never<br>
&gt; bothered to create a thread.<br>
<br>
Yeah, to be clear: A big goal of this is definitely to be used by<br>
poolers/proxies/middleware. Those systems will often be more frequently<br>
restarted than the actual database servers, so being able to do that<br>
quickly without disrupting active connections is much more important<br>
there than with plain PostgreSQL servers.<br>
<br>
&gt; About patches:<br>
<br>
Thanks for the review. Attached is a new patchset. I think I addressed<br>
all of your comments (I almost fully rewrote the docs). I also fixed<br>
two other issues that I found: <br>
- updating docs for 3.3 in more places<br>
- handling the GoAway message in more code paths on the client side<br>
<br>
</blockquote></div>

--0000000000009d3c530644dced49--