postgresql11: How to use publication/subscription on primary/standby setup

From: Abhishek B <abhishekbhola05(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: postgresql11: How to use publication/subscription on primary/standby setup
Date: 2021-09-29 09:01:46
Message-ID: CAHHOhf3ZZW7GPLUJYcM5c_onUN1m+ccdGjemoOBnqb_jXkhXew@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2021-09-29 09:26:07 Using a single sequence for all tables
Previous Message Tom Lane 2021-09-28 20:15:14 Re: statement_timeout vs DECLARE CURSOR