pgraft
PostgreSQL Raft Consensus Extension
PostgreSQL High Availability Solution
Leader election uses quorum-based voting. Uses etcd-io/raft for deterministic results.
Replication persists all state changes across nodes. Survives crashes and network partitions.
Split-brain prevention uses Raft consensus. Ensures one leader per term.
Failover completes in under one second. No service interruption during failover.
Uses etcd-io/raft library. Same library used by etcd and Kubernetes.
Products
PostgreSQL High Availability Solution with automatic failover, zero-downtime clustering, connection pooling, monitoring, and distributed consensus.
pgraft
Raft consensus for PostgreSQL with automatic leader election and split-brain prevention.
- •Automatic leader election
- •Split-brain prevention
- •Zero-downtime failover
- •etcd-io/raft based
- •Background worker architecture
pgBalancer
Connection pooler with load balancing, REST API, and machine learning query routing.
- •AI-powered load balancing
- •REST API (17 endpoints)
- •MQTT event streaming
- •Connection pooling
- •YAML configuration
pg_stat_insights
Performance analytics extension with query analysis and optimization recommendations.
- •Query performance analysis
- •Table and index statistics
- •Cache hit ratio monitoring
- •Optimization recommendations
- •52 metrics across 11 views
pgSentinel
Monitoring platform with Grafana dashboards, Prometheus integration, and real-time metrics.
- •Grafana dashboards
- •Prometheus integration
- •Real-time metrics
- •Alerting system
- •Docker deployment