Logical decoding plus streaming replication fail-over - Mailing list pgsql-general

From Igor Polishchuk
Subject Logical decoding plus streaming replication fail-over
Date
Msg-id CAEcs1Y4iw0yo2SjtCH5-WO1jNA4f6xEU35dhOHd9-tvDUa0ixw@mail.gmail.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: got stuck in pglogical upgrade on FreeBSD
Next
From: Ancoron Luciferis
Date:
Subject: Re: Index with new opclass not used for sorting