Re: Add GoAway protocol message for graceful but fast server shutdown/switchover

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(at)jeltef(dot)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(at)jeltef(dot)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
>
>