Clarification relation logical replication

From: Santhosh Kumar <krssanthosh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Clarification relation logical replication
Date: 2020-05-19 17:25:05
Message-ID: CANCPq3iTDZfRpuxiugcUmVHxvRS-zw-WT0L-+8tF-pwR6-zG-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Albrecht Dreß 2020-05-19 17:43:14 Re: Unique index on hash of jsonb value - correct solution?
Previous Message Adrian Klaver 2020-05-19 17:13:56 Re: idle_in_transaction_session_timeout not getting log in PG v12.2