Automated PostgreSQL high availability
pg_auto_failover monitors PostgreSQL nodes and manages failover automatically using native PostgreSQL streaming replication. A clear, predictable HA model without complex external orchestration.
Automatic promotion with zero data loss
pg_auto_failover runs a monitor that tracks the health of primary and standby nodes. When the primary fails, the monitor promotes the standby and reconfigures the cluster — no manual intervention, no data loss, no external dependencies.
Manual failover is slow and error-prone under pressure
Where pg_auto_failover fits
Built on PostgreSQL native features
Active maintenance areas
Current work focuses on PostgreSQL version compatibility, Kubernetes operator integration, stability improvements for edge cases in network partition scenarios, and documentation.
Queue, SLA, quarterly releases
Work is prioritized through a queue. Supported users receive priority handling, with defined response times. Fixes and improvements are grouped and shipped in quarterly releases.
Open source and available now
pg_auto_failover is open source and available as a PostgreSQL extension. Packages are available for Debian, Ubuntu, and RPM-based distributions, and a Docker image is provided.
Keep high availability reliable
If pg_auto_failover protects your production PostgreSQL cluster, supporting its maintenance ensures continued compatibility, faster fixes, and confidence in the behaviour you depend on.
Sharpen your skills, improve reliability, move faster
If you run PostgreSQL in production, the difference is not just tooling—it's how well you use it. Query design, data modeling, migrations, and performance tuning directly impact reliability and delivery speed.
The Art of PostgreSQL offers a complete, structured program to help you level up: from fundamentals to advanced production patterns, with practical, hands-on material you can apply immediately.