This is actually a missing piece in Postgres. It was neatly blogged here. https://www.percona.com/blog/2020/05/21/failover-of-logical-replication-slots-in-postg

This is actually a missing piece in Postgres. It was neatly blogged here. https://www.percona.com/blog/2020/05/21/failover-of-logical-replication-slots-in-postgresql/ https://www.percona.com/blog/2020/05/21/failover-of-logical-...