5 ms·
The most common way to achieve HÁ is using Patroni. The easiest way to set it up is using Autobase (https://autobase.tech https://autobase.tech). CloudNativePG
by mfalcao 9mo ago
The most common way to achieve HÁ is using Patroni. The easiest way to set it up is using Autobase (https://autobase.tech https://autobase.tech).
CloudNativePG (https://cloudnative-pg.io https://cloudnative-pg.io) is a great option if you’re using Kubernetes.
There’s also pg_auto_failover which is a Postgres extension and a bit less complex than the alternatives, but it has its drawbacks.
- franckpachot 9mo agoBe sure to read the Муths and Truths about Synchronous Replication in PostgreSQL (by the author of Patroni) before considering those solutions as cloud-native high availability: https://www.postgresql.eu/events/pgconfde2025/sessions/session/6559/slides/663/Myths%20and%20Truths%20about%20Synchronous%20Replication%20in%20PostgreSQL.pdf https://www.postgresql.eu/events/pgconfde2025/sessions/sessi...
- da02 9mo agoWhat is your preferred alternative to Patroni?