Postgres Pro
Downloads
Home   >   mailing lists

postgresql11: How to use publication/subscription on primary/standby setup - Mailing list pgsql-general

From Abhishek B
Subject postgresql11: How to use publication/subscription on primary/standby setup
Date
Msg-id CAHHOhf3ZZW7GPLUJYcM5c_onUN1m+ccdGjemoOBnqb_jXkhXew@mail.gmail.com
Whole thread Raw
Responses Re: postgresql11: How to use publication/subscription on primary/standby setup  (Tomas Pospisek <tpo2@sourcepole.ch>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: statement_timeout vs DECLARE CURSOR
Next
From: "Peter J. Holzer"
Date:
Subject: Using a single sequence for all tables