[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    postgresql11: How to use publication/subscription on primary/standby setup
From:       Abhishek B <abhishekbhola05 () gmail ! com>
Date:       2021-09-29 9:01:46
Message-ID: CAHHOhf3ZZW7GPLUJYcM5c_onUN1m+ccdGjemoOBnqb_jXkhXew () mail ! gmail ! com
[Download RAW message or body]

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

[Attachment #3 (text/html)]

Is there a solution to use publication/subscription on a master-slave or \
primary-standby postgres setup without manual intervention?<div \
dir="auto"><br></div><div dir="auto">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?  \
</div><div dir="auto"><br></div><div dir="auto">Thanks and regards,</div><div \
dir="auto">Abhishek Bhola</div>



[prev in list] [next in list] [prev in thread] [next in thread]