Monitoring EDB Postgres Distributed v9

Suggest edits

EDB Postgres Distributed provides multi-master replication and data distribution with advanced conflict management, data-loss protection, and throughput up to 5X faster than native logical replication, and enables distributed PostgreSQL clusters with high availability up to five 9s. Before you monitor nodes in a EDB Postgres Distributed cluster through the PEM console, you must first deploy a EDB Postgres Distributed cluster and ensure that your database nodes are up and running. For more information on installing EDB Postgres Distributed see EDB Postgres Distributed.

You can configure PEM to display status information about one or more EDB Postgres Distributed database nodes using dashboards in PEM version 8.1.0 and EDB Postgres Distributed version 3.7.9 and later.

To configure PEM to monitor EDB Postgres Distributed database nodes, use the PEM web client to create a server definition. Use the tabs on the New Server Registration dialog box to specify general connection properties for the EDB Postgres Distributed database node with the following exceptions:

  • Specify the EDB Postgres Distributed-enabled database name in the Database field of the PEM Agent tab.

  • Specify the user having the pgd_monitor or pgd_superuser role in the username field of the PEM Agent tab.

After saving the server definition, the EDB Postgres Distributed database node is included in the list of servers under the PEM server directory in the PEM client object browser tree. You can monitor the nodes from EDB Postgres Distributed (PGD) dashboards.

To include monitoring information on the EDB Postgres Distributed (PGD) dashboards, you must enable the relative probes for each EDB Postgres Distributed group. See the complete list of EDB Postgres Distributed probes.

To enable a probe, right-click the node name, and select Management > Manage Probes.

To monitor the EDB Postgres Distributed database node, right-click the name of the node in the object browser tree. From the Dashboards menu, select the PGD Admin, PGD Group Monitoring, or PGD Node Monitoring dashboard.