On Mon, Jun 19, 2023 at 11:34 AM Drouvot, Bertrand <bertranddrouvot...@gmail.com> wrote: > > Also I think we need to handle the case of invalidated replication slot(s): > should > we drop/recreate it/them? (as the main goal is to have sync slot(s) on the > standby). >
Do you intend to ask what happens to logical slots invalidated (due to say max_slot_wal_keep_size) on publisher? I think those should be invalidated on standby too. Another thought whether there is chance that the slot on standby gets invalidated due to conflict (say required rows removed on primary)? I think in such cases the slot on primary/publisher should have been dropped/invalidated by that time. BTW, does the patch handles drop of logical slots on standby when the same slot is dropped on publisher/primary? -- With Regards, Amit Kapila.