pglogical icon indicating copy to clipboard operation
pglogical copied to clipboard

logical replication slots are not available in secondary server while using pglogical on High availablity.

Open manim549 opened this issue 2 years ago • 1 comments

Hi All, I am using pglogical replication to create read replicas for certain tables in different DB from primary azure managed flexi server which have High availability configuration. At the time of failover, when Standby becomes primary, getting error, replication slot not available. Its an limitation. How to manage pglogical replication in slave servers at the time of Failover. If there is any best practices available, kindly share the same.

Please find high level setup as below Master With HA config

Primary<--->Secondary

Slave

Created by pglogical replication for certain tables

Thanks and regards, Manimahesh S

manim549 avatar Jul 01 '22 09:07 manim549

Logical failover is not supported with pglogical 2.

petere avatar Jul 01 '22 14:07 petere