[Feature] Add support for cascading replication

Currently failover slots are only synchronised from the primary to the standby(s), not the other way around. Postgres 16 has added support for cascading replication, where the active slot is actually on the standby (and might be initially created there). It would be nice to add failover slots support for this scenario.

Is there any work done already in this direction?