Patroni Cluster Management with BFM4Patroni

Patroni is a widely used open-source tool that provides high availability for PostgreSQL. When performing operations with Patroni, it is necessary to connect to the servers via SSH. Tasks such as switchover, pause/resume, show/edit configuration, and viewing the replication list are carried out manually from the Linux command line.

Additionally, to view PostgreSQL and Patroni logs for each server, you must connect to each one via SSH, navigate to the relevant log directory, and manually examine the logs. In a typical Patroni setup, accessing services like etcd, HAProxy, and Patroni for general monitoring and control also requires connecting to each server individually. All of these tasks are manual. Furthermore, the PostgreSQL Patroni HA cluster does not have a built-in notification or alert mechanism—custom development is needed for this. If there is more than one Patroni cluster, monitoring and management become even more complex, as each member server must be accessed, controlled, and managed separately.

BFM4Patroni

Manage, monitor, and track all your Patroni clusters from a single web-based interface.

What you can do with BFM4Patroni:

Patroni Operations via Web GUI

• Failover

• Switchover

• Re-initialize

• Pause / Resume

• Show / Edit Configuration

  
  

Log Tracking

Monitor logs for Patroni, HAProxy, and PostgreSQL cluster members, including system activities and errors.

Performance Insights & Advisor

• Monitor top SQL queries and execution plans

• View top sessions and session lock details within a selected Patroni cluster and date range

• Visualize historical active sessions

• Receive index optimization recommendations

  
  

Helth Monitoring

Access detailed health status for Patroni, HAProxy, and PostgreSQL services through the web interface.

Notifications

Receive alerts (e.g., via email) on cluster health status, failovers, switchovers, and other critical events.

Multi-Cluster Management

Monitor multiple Patroni clusters simultaneously from a single BFM4Patroni dashboard.

Secure Web Access

Supports HTTPS and authentication to ensure secure and authorized access to the web interface.

API Integration

BFM4Patroni offers API support, allowing seamless integration with your Ansible playbooks for automated cluster management.