Postgres 17 changed an important part of the CDC failover story: logical replication slots can now survive a primary promotion.

With HA configured, a logical slot can sync to a standby and survive promotion, preserving Postgres’s record of where CDC left off. But it does not