Logical Decoding Failover - Mailing list pgsql-general

From Colin Morelli
Subject Logical Decoding Failover
Date
Msg-id CAPtU-UqNOdduGa1YAbZLRFcDJnud57i2zgUCE_PaWrP0UZ4=HA@mail.gmail.com
Whole thread Raw
Responses Re: Logical Decoding Failover  (Venkata Balaji N <nag1010@gmail.com>)
Re: Logical Decoding Failover  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-general
Hey all,

I'm using logical decoding in my application to capture change streams and ship them to Kafka. However, logical replication slots aren't included in the WAL and thus don't make it to replicas. In the case of a failover, it's not clear what (if anything) can be done to continue receiving a change stream.

I noticed there was a failover slot patch that looks like it won't be making it for 9.6 (if at all), but does anyone else have suggestions for handling failover + logical decoding? Is there an answer, or is it limited to being a very manual process for now?

Thanks in advance.

Best,
Colin

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Uber migrated from Postgres to MySQL
Next
From: Patrick B
Date:
Subject: Re: Question about wal files / pg_xlogs