A PostgreSQL Cluster is a high-availability and fault-tolerant configuration of the PostgreSQL database management system. This setup consists of multiple interconnected database nodes that work together to provide data redundancy and ensure continuous operation.

A PostgreSQL Cluster automatically fails over to a standby node in the event of a failure, minimizes downtime, enhances data reliability for mission-critical applications, improves scalability, and boosts performance for demanding environments.

A PostgreSQL Cluster also supports load balancing to distribute user requests efficiently, enables data distribution for managing large data volumes, and facilitates concurrent access for enterprise-level applications such as e-commerce platforms and financial systems.

Key Benefits

  • Device discovery provides a unified view of all elements in a Linux cluster and their relationships.
  • Device monitoring tracks metrics over time and sends alerts to the customer team for immediate action if thresholds are breached or unexpected behavior occurs, ensuring smooth business operations with minimal or zero downtime during infrastructure issues.

Supported Target Version

Validated the application against the PostgreSQL Cluster with below specifications:

  • 3 linux nodes (Ubuntu 20.04 LTS) + 1 haproxy node (Ubuntu 20.04 LTS)
  • Clustering manager: patroni 2.1.4
  • etcd version: 3.2.26

Resource Hierarchy

      • PostgreSql Cluster
              • PostgreSql Node
              • PostgreSql Database

Version History

Application VersionBug fixes / Enhancements
2.0.0Added support for PostgreSql Database.
1.0.1
  • Added code support for Get Target Response command for each native type.
  • On demand latest snapshot support and Activity logger changes
1.0.0Initial support for PostgreSQL Cluster application.