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