Support HA for logical replication slots

[sjuls]

Currently CloudNativePG supports HA replication slots for physical replication slots, but ignores logical replication slots. To better support connectors such as debezium which require the replication slot to be available upon connection, it would make sense to extend the current behaviour to also synchronize logical replication slot from the primary to the standby's and advance the LSN in the configured interval.

This would also protect against excessive WAL piling up on a standby risking running out of disk, since the consumer will likely consumer from the primary instance.

Similar comments have been made to issue 13, though the issue seems to have an overall different goal, hence the separate issue I am creating here.

[nmargaritis]

Hello, what's the status of this?

[ntx-ben]

Also looking forward to this for Debezium support

[justinwyer]

Is any community contribution needed to move this forward?

[ironytr]

any update?

[ozen]

Looks like this is not an issue anymore sine the pg_failover_slots extension is the solution:

#1997 (comment)

[sjuls]

@ozen I agree, closing.