Re: Exit walsender before confirming remote flush in logical replication - Mailing list pgsql-hackers

From Vitaly Davydov
Subject Re: Exit walsender before confirming remote flush in logical replication
Date
Msg-id 1a9d89-68d67480-1b-29edfa00@90613631
Whole thread Raw
In response to Re: Exit walsender before confirming remote flush in logical replication  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: Improve pg_sync_replication_slots() to wait for primary to advance
Next
From: Dilip Kumar
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication