4 ms·
I was just yesterday talking to someone about this; they mentioned that Patroni leverages some way for setting up replication slots on replicas [1]. Haven't tri
by gunnarmorling 5y ago
I was just yesterday talking to someone about this; they mentioned that Patroni leverages some way for setting up replication slots on replicas [1]. Haven't tried my self yet, but seems worth exploring.
Something I'd like to dive into within Debezium is usage of the pg_tm_aux extension, which supposedly allows to set up replication slots "in the past", so you could use this to have seamless failover to replicas without missing any events. In any case, this entire area is of high importance for us and we're keeping an eye on any improvements closely, so I hope it will be sorted out sooner or later.
[1] https://twitter.com/cyberdemn/status/1443130986116624388 https://twitter.com/cyberdemn/status/1443130986116624388
[2] https://github.com/x4m/pg_tm_aux https://github.com/x4m/pg_tm_aux
- anarazel 5y agoThat extension is not safe / correct afaict.