Re: Seamless Logical Replication during Fail-over

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