Horton

Re: Exit walsender before confirming remote flush in logical replication

Vitaly Davydov <v.davydov@postgrespro.ru>

View thread
From: "Vitaly Davydov" <v.davydov@postgrespro.ru>
To: "Greg Sabino Mullane" <htamfids@gmail.com>
Cc: "Kyotaro Horiguchi" <horikyota.ntt@gmail.com>, andres@anarazel.de, amit.kapila16@gmail.com, kuroda.hayato@fujitsu.com, smithpb2250@gmail.com, osumi.takamichi@fujitsu.com, pgsql-hackers@postgresql.org, sawada.mshk@gmail.com, michael@paquier.xyz, peter.eisentraut@enterprisedb.com, dilipbalaut@gmail.com
Date: 2025-09-26T11:10:02Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add wal_sender_shutdown_timeout GUC to limit shutdown wait for replication

  2. pg_upgrade: Add --copy option

  3. Prevent possibility of panics during shutdown checkpoint.

  4. Support clean switchover.

Dear Greg, All

I'm interested in walsender shutdown mode option as well. Unexpected waiting for
wal sender shutdown in fast mode creates some problems to follow a SLA. I also
propose to create a GUC which can be used to set the shutdown mode globally.
Once, the original author was not responded for some time, I like the idea to
create a new separate patch for walsender shutdown mode based on the work in
this thread. I'm ready to participate in patch preparation and testing.

With best regards,
Vitaly

On Tuesday, September 17, 2024 15:29 MSK, Greg Sabino Mullane <htamfids@gmail.com> wrote:

> Thanks for everyone's work on this, I am very interested in it getting into
> a release. What is the status of this?
> 
> My use case is Patroni - when it needs to do a failover, it shuts down the
> primary. However, large transactions can cause it to stay in the "shutting
> down" state for a long time, which means your entire HA system is now
> non-functional. I like the idea of a new flag. I'll test this out soon if
> the original authors want to make a rebased patch. This thread is old, so
> if I don't hear back in a bit, I'll create and test a new one myself. :)
> 
> Cheers,
> Greg