On Tue, 8 Dec 2020 at 17:54, Andrey Borodin <x4...@yandex-team.ru> wrote:
> > In pglogical3 we already support streaming decoded WAL data to > alternative writer downstreams including RabbitMQ and Kafka via writer > plugins. > Yes, Yandex.Cloud Transfer Manger supports it too. But it has to be > resynced after physical failover. And internal installation of YC have > mandatory drills: few times in a month one datacenter is disconnected and > failover happens for thousands a DBS. > You'll want to look at https://wiki.postgresql.org/wiki/Logical_replication_and_physical_standby_failover#All-logical-replication_HA then.