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
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 |