pglookout: PostgreSQL Replication Monitoring and Failover Daemon
pglookout is a robust monitoring and failover solution designed for PostgreSQL replication clusters. It actively monitors the replication status of database nodes and executes predefined actions, such as promoting a new primary node in the event of a failure, ensuring high availability and reliability in database environments.
Features
Supports monitoring of PostgreSQL versions 10 and above.
Can operate with both installed database nodes and external observer nodes for enhanced monitoring.
Facilitates simultaneous observation of multiple replication clusters with a single observer.
Customizable failover commands for automated handling of primary node failures.
Comprehensive JSON configuration for easy setup and management of monitoring parameters.
Generates alert files for various error conditions, enabling proactive incident management.
Integrates with systemd or Supervisor for reliable process control and management.