On Wed, Nov 8, 2023 at 12:32 PM Drouvot, Bertrand <bertranddrouvot...@gmail.com> wrote: > > Hi, > > On 11/8/23 4:50 AM, Amit Kapila wrote: > > > I think if we want to follow > > this approach then we need to also monitor these slots for any change > > in the consecutive cycles and if we are able to sync them then > > accordingly we enable them to use after failover. > > What about to add a new field in ReplicationSlotPersistentData > indicating that we are waiting for "sync" and drop such slots during > promotion and > /or if not in recovery? >
This patch is already adding 'synced' flag in ReplicationSlotPersistentData to distinguish synced slots so that we can disallow decoding on then in standby and disallow to drop those. I suggest we change that field to have multiple states where one of the states would indicate that the initial sync of the slot is done. -- With Regards, Amit Kapila.
