Doc: Add the new section "Logical Replication Failover".

Fix the review comments and a bug in the slot sync code.

Fix a test in failover slots regression test.

Fix the intermittent buildfarm failures in 040_standby_failover_slots_sync.

Ensure that the sync slots reach a consistent state after promotion without losing data.