Seamless Logical Replication during Fail-over

From: Moor Ali <moorali(dot)d(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Seamless Logical Replication during Fail-over
Date: 2020-05-15 10:05:27
Message-ID: CAFmHKA6oXGNn+OG9mBDCXR9+wVXP36iA1k8yq69J-y5_a=xKMA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is there any way to continue logical replication (either in-built or using
pglogical) between a promoted replica and existing subscribers without data
loss?

I could find some discussions about fail-over slots and other mechanisms
for addressing this as part of PostgreSQL 9.6 release. But I am not sure if
these changes made it to any of the releases.

The use-case is as follows:
* Cluster A with a master and two or more replicas using synchronized
streaming replication
* Cluster B containing a node which uses logical replication with Cluster A
master. There may be a lag in updating this node.
* When Cluster A master goes down, a replica is promoted but it does not
have any information about the logical replication slots created in the
master. So, even if a new slot is created on the replica, there will be
data loss on the subscriber side.

Any suggestions on how to address this using builtin mechanisms or using an
extension are welcome.

Thanks,
Murali

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gavan Schneider 2020-05-15 11:54:16 Re: PG12.2 Configure cannot enalble SSL
Previous Message PALAYRET Jacques 2020-05-15 09:01:55 Circles with circle() vs ST_Buffer() Equality equalities