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
