Patroni cluster connection with slot failover - is it supported by Debezium?

[Maksim Samsonov]

Hello!

Could you please advise if Debezium can support failover on patroni cluster with  sync_slots  enabled?

According to docs there is slot.failover parameter, but I don't uderstand how it can work with only one host in database.hostname parameter.

Is haproxy required for Debezium to connect or there is a possibility to specify multiple hosts with target_sess_attr?

Thanks in advance! 

[jiri.p...@gmail.com]

Hi,

the slot.failover is about https://www.postgresql.org/docs/current/logical-replication-failover.html

This ensures that the LSN numbering is consistent between master and replica. And yes if you want automated failover then you'd need to rely on haproxy or you'd ned to manually update/switch hostname.

Unfortunately I cannot say anything about Patroni. But if Patroni can guarantee LSN numbering to be consistent then it is safe to use it too.

WRT slot.failover - this is used in createion of the slot only so if the slot already exists then the setting is not used at all.

Jiri

[Maksim Samsonov]

Hi,

Thank you for the clarification!

пятница, 7 ноября 2025 г. в 11:02:27 UTC+3, jiri.p...@gmail.com: