Clarification relation logical replication

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Clarification relation logical replication

Santhosh Kumar-2
Hi,
 Can I have a cluster of multiple instances with logical replication enabled for all tables with every single instance as both publisher and subscriber, to mimic multi master replication?

The documentation says, care must be taken on subscribed publication objects to not overlap? Ref : https://www.postgresql.org/docs/12/logical-replication-subscription.html

"A subscriber node may have multiple subscriptions if desired. It is possible to define multiple subscriptions between a single publisher-subscriber pair, in which case care must be taken to ensure that the subscribed publication objects don't overlap."


If the above multi master scenario is not possible in logical replication, and if is one publisher and multiple subscribers, what will happen if the publisher instance crashes? How to enable hot standby in cluster setup where there is one publisher of logical replication and rest all instances are subscribers?

Regards,
KRS