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