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