Re: Add GoAway protocol message for graceful but fast server shutdown/switchover - Mailing list pgsql-hackers

From Ajit Awekar
Subject Re: Add GoAway protocol message for graceful but fast server shutdown/switchover
Date
Msg-id CAER375Nugod9uuowwEUAai9PpoXP2xD-G54MW6hhjQw-6LtSLQ@mail.gmail.com
Whole thread Raw
In response to Re: Add GoAway protocol message for graceful but fast server shutdown/switchover  ("Jelte Fennema-Nio" <postgres@jeltef.nl>)
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: Parallel Apply
Next
From: Soumya S Murali
Date:
Subject: Re: [PATCH] Expose checkpoint timestamp and duration in pg_stat_checkpointer