Обсуждение: Clarification relation logical replication

Поиск
Список
Период
Сортировка

Clarification relation logical replication

От
Santhosh Kumar
Дата:
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