Logical decoding plus streaming replication fail-over

From: Igor Polishchuk <ora4dba(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Logical decoding plus streaming replication fail-over
Date: 2019-06-21 20:45:19
Message-ID: CAEcs1Y4iw0yo2SjtCH5-WO1jNA4f6xEU35dhOHd9-tvDUa0ixw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Did anybody solve a problem of logical replication slot fail-over on a
streaming replication cluster?

I have a logical decoding on a logical replication slot set up on a
streaming replication master.
Streaming replication does not propagate the replication slot state. In
case of fail-over, I need to create a new replication slot on a new muster
and loose some database changes.
Is there any work-around that would allow avoid loosing database changes on
a logical replication slot after a fail-over?

Postgres 10.8 on CentOS 7.

--
Thanks
Igor Polishchuk

Browse pgsql-general by date

  From Date Subject
Next Message Ancoron Luciferis 2019-06-21 21:14:30 Re: Index with new opclass not used for sorting
Previous Message Adrian Klaver 2019-06-21 16:27:50 Re: got stuck in pglogical upgrade on FreeBSD