As of version 17, Postgres finally supports failover for replication slots: pg_create_logical_replication_slot() has a new optional parameter for creating slots enabled for failover to replicas. Such a slot can be synchronized to replicas either manually (by calling pg_sync_replication_slots() on the stand-by) or automatically (by enabling sync_replication_slots), allowing clients like Debezium to consume from that slot after a failover, without missing any events.

This requires slots to be created using this new parameter. So we'll need to add support for this to Debezium. Unfortunately, we cannot just always pass this option, since as of version 17, failover slots can only be created on primary servers, but not on stand-by servers, and users may explicitly want to do the latter.