Is there a solution to use publication/subscription on a master-slave or primary-standby postgres setup without manual intervention?
Currently the DB clusters are managed by Pacemaker. Once there is a failover, the pacemaker is able to promote the secondary node to primary, but the logical replication stops working after that. Is there any way to automatically move the contents of pg_replslot to the new primary node?
Thanks and regards,
Abhishek Bhola