pg_auto_failover

Automatic failover for PostgreSQL

pg_auto_failover monitors PostgreSQL and automatically manages failover to maintain high availability. Built on PostgreSQL native features for zero data loss.

What pg_auto_failover does

High availability built on PostgreSQL

pg_auto_failover is a service that monitors and manages failover for PostgreSQL. It coordinates replication between primary and standby nodes and automatically promotes a standby when the primary fails.

Why it matters

Availability matters in production

  • PostgreSQL's streaming replication is robust
  • Managing failover manually is error-prone
  • pg_auto_failover automates the entire process
  • Maintains zero data loss through synchronous replication

Typical use cases

Where pg_auto_failover fits

  • Multi-node HA clusters
  • Zero-downtime maintenance
  • Cloud-native deployments
  • Compliance-driven HA requirements

Key capabilities

Built on PostgreSQL native features

  • Automatic failover with zero data loss
  • Synchronous replication
  • Health monitoring for primary and standby
  • Simple setup and maintenance
  • PostgreSQL native streaming replication

Current focus

Active maintenance areas

Current work focuses on improving failover speed, better monitoring and metrics, multi-standby configurations, and PostgreSQL version compatibility.

How maintenance works

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.

Get pg_auto_failover

Open source and available now

pg_auto_failover is open source and developed in public.

Support pg_auto_failover

Keep your database available

If pg_auto_failover is part of your HA strategy, supporting its maintenance ensures faster fixes, continued compatibility, and long-term reliability.

Get the most out of PostgreSQL in production

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.

We provide a complete, structured program to help you level up: from fundamentals to advanced production patterns, with practical, hands-on material you can apply immediately.