Обсуждение: postgresql11: How to use publication/subscription on primary/standby setup

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