[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: postgresql11: How to use publication/subscription on primary/standby setup
From: Tomas Pospisek <tpo2 () sourcepole ! ch>
Date: 2021-10-01 12:03:29
Message-ID: e1d579b9-6734-9e39-708b-cd4b7b95a4c4 () sourcepole ! ch
[Download RAW message or body]
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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic