Patroni

Patroni at a glance

Patroni is a widely used open-source template for building highly available PostgreSQL clusters with automatic failover, common in production Postgres deployments. Patroni ships regular releases plus fixes; as the component managing database failover, careful updates are essential.

For admins Patroni orchestrates PostgreSQL HA using a distributed configuration store (etcd, Consul or ZooKeeper), so its version, PostgreSQL's, and the DCS's must all stay compatible — plan upgrades together and read the release notes. Because Patroni controls failover, a bad upgrade or misconfiguration can cause split-brain or an unwanted failover — test in a non-production cluster, and back up first. Update cluster members in a controlled, rolling way. Its REST API and the DCS belong on a protected network. After upgrading, verify that the cluster elects a leader, replication is healthy and failover works as expected. Track the version and its support status; patchletter surfaces new Patroni releases so fixes land.