Introduction¶
Patroni is a template for you to create your own customized, high-availability solution using Python and - for maximum accessibility - a distributed configuration store like ZooKeeper, etcd, Consul or Kubernetes. Database engineers, DBAs, DevOps engineers, and SREs who are looking to quickly deploy HA PostgreSQL in the datacenter-or anywhere else-will hopefully find it useful.
We call Patroni a “template” because it is far from being a one-size-fits-all or plug-and-play replication system. It will have its own caveats. Use wisely. There are many ways to run high availability with PostgreSQL; for a list, see the PostgreSQL Documentation.
Currently supported PostgreSQL versions: 9.3 to 15.
Note to Citus users: Starting from 3.0 Patroni nicely integrates with the Citus database extension to Postgres. Please check the Citus support page in the Patroni documentation for more info about how to use Patroni high availability together with a Citus distributed cluster.
Note to Kubernetes users: Patroni can run natively on top of Kubernetes. Take a look at the Kubernetes chapter of the Patroni documentation.
Contents:
- Introduction
- Citus support
- Patroni configuration
- DCS Failsafe Mode
- Patroni REST API
- Convert a Standalone to a Patroni Cluster
- Major Upgrade of PostgreSQL Version
- Environment Configuration Settings
- YAML Configuration Settings
- Security Considerations
- Replica imaging and bootstrap
- Replication modes
- Pause/Resume mode for the cluster
- Using Patroni with Kubernetes
- Watchdog support
- Release notes
- Version 3.0.1
- Version 3.0.0
- Version 2.1.7
- Version 2.1.6
- Version 2.1.5
- Version 2.1.4
- Version 2.1.3
- Version 2.1.2
- Version 2.1.1
- Version 2.1.0
- Version 2.0.2
- Version 2.0.1
- Version 2.0.0
- Version 1.6.5
- Version 1.6.4
- Version 1.6.3
- Version 1.6.2
- Version 1.6.1
- Version 1.6.0
- Version 1.5.6
- Version 1.5.5
- Version 1.5.4
- Version 1.5.3
- Version 1.5.2
- Version 1.5.1
- Version 1.5.0
- Version 1.4.6
- Version 1.4.5
- Version 1.4.4
- Version 1.4.3
- Version 1.4.2
- Version 1.4.1
- Version 1.4
- Version 1.3.6
- Version 1.3.5
- Version 1.3.4
- Version 1.3.3
- Version 1.3.2
- Version 1.3.1
- Version 1.3
- Version 1.2
- Version 1.1
- Version 1.0
- Version 0.90
- Version 0.80
- Contributing guidelines