Thread: postgresql11: How to use publication/subscription on primary/standby setup
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
Re: postgresql11: How to use publication/subscription on primary/standby setup
From
Tomas Pospisek
Date:
On 29.09.21 11:01, Abhishek B wrote: > 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? I'm not sure I understand you correctly, but I'd suggest to have a look at patroni, which maybe does what you want. *t