Clarification relation logical replication - Mailing list pgsql-general

From Santhosh Kumar
Subject Clarification relation logical replication
Date
Msg-id CANCPq3iTDZfRpuxiugcUmVHxvRS-zw-WT0L-+8tF-pwR6-zG-Q@mail.gmail.com
Whole thread Raw
List pgsql-general
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: idle_in_transaction_session_timeout not getting log in PG v12.2
Next
From: Albrecht Dreß
Date:
Subject: Re: Unique index on hash of jsonb value - correct solution?