Postgres Enterprise Manager 10.0.0 release notes v10

PEM 10 introduces the concept of Clusters. These are groupings of Servers and Agents used to represent a High Availability (HA) cluster, for example a cluster using Postgres Distributed or EDB Failover Manager. You can create and populate Clusters in the Object Explorer. In future releases we will expand this functionality to improve the experience of working with HA clusters in PEM.

PEM now supports arbitrary tagging of servers. Presently this is purely a cosmetic feature. In the future we will expand it to support filtering and selection by tags.

The entire PEM user interface has been ported to the React framework. This brings the PEM project back into line with pgAdmin, making it easier for us to ull enhancements from the upstream. It also delivers a more modern and performant interface. We have taken advantage of this porting to make numerous improvements to the UI including:

• Added pagination in Probes/Alerts.
• Implemented workspaces.
• Divided scheduled tasks into Task and History tabs.
• Implemented a dialog view for creating Alerts, Probes and other objects, replacing the grid view.

The updated architecture of PEM 10 has allowed us to pull many enhancements from pgAdmin including:

• Generate Entity Relationship Diagrams
• Plot charts in Query Tool results
• Show real-time system metrics dashboard using the systemstats extension

This data can be used to monitor and alert on IOPS (Input/Output Operations Per Second), which is of particular relevance when using cloud storage.

The node_type may take one of the following values: primary, replica, readonly, standalone.

Panels/Tabs for the following PEM components will be opened in the 'Enterprise Manager' workspace:

• Alert templates
• Email group
• Webhooks
• Custom probes
• Manage Charts

Panels/Tabs for the following PEM components will be opened in the 'Enterprise Tools' workspace:

• SQL Profiler
• Performance diagnosis
• Capacity manager report

Panels/Tabs for the following PEM components will be opened in the 'Object Explorer' workspace:

• Probe configuration
• Alerts

PEM 10 supports both Apache HTTPD and NGINX as the web server on Linux. On Windows only Apache HTTPD is supported. The default for new installations is NGINX. Upgrades from PEM 9 will continue to use Apache HTTPD unless you opt to switch the web server by running the /usr/edb/pem/bin/switch-web-server.sh script.

You can now specify a minimum query duration when creating a trace in SQL Profiler. This allows you to only trace long-running queries, which in turn means you can run a trace for a much longer period without exceeding the size limit.

This is configurable via the alert_reconnect_delay parameter in agent.cfg.

These features have been removed from PEM 10.0 onwards. For Postgres tuning we recommend the EDB Postgres Tuner extension and the accompany web utility. The Index Advisor extension for EDB Server has been deprecated and replaced by EDB Query Advisor, which is compatible with all Postgres distributions. For log analysis we recommend pgBadger.