| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Moor Ali <moorali(dot)d(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Seamless Logical Replication during Fail-over |
| Date: | 2020-05-15 12:31:50 |
| Message-ID: | e0e989d9-7538-193e-95dd-c567ce45dcdc@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2020-05-15 12:05, Moor Ali wrote:
> 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.
You are right that the fail-over slot mechanism was supposed to address
this but it never made it into a release. I'm not aware of an
open-source solution for this right now.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rory Campbell-Lange | 2020-05-15 13:02:46 | Re: Inherited an 18TB DB & need to backup |
| Previous Message | Peter Eisentraut | 2020-05-15 12:27:48 | Re: PG12.2 Configure cannot enalble SSL |