pglogical
pglogical copied to clipboard
logical replication slots are not available in secondary server while using pglogical on High availablity.
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
Logical failover is not supported with pglogical 2.