Thread: Logical decoding plus streaming replication fail-over

Logical decoding plus streaming replication fail-over

From
Igor Polishchuk
Date:
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