Postgres Enterprise Manager 9.5.0 release notes#

Released: 15 Feb 2024

New features, enhancements, bug fixes, and other changes in PEM 9.5.0 include:

Type

Description

Enhancement

Added EmailGroup and EmailGroupID in webhook payload.

Enhancement

Added an alert template to validate password expiry for users in EDB Postgres Advanced Server. Also modified the alert template A user expired in N days to Number of users expiring in N days that checks the number of users expiring.[^*]

Enhancement

Added a button on the Manage Probes window that resets the probe configurations to the defaults.

Enhancement

Added a Cleared Alert button in notifications. This gives you the flexibility to disable notifications for cleared alerts while still receiving notifications when alerts occur.

Enhancement

You can now create your own web server certificates, as EDB details are no longer added to the web server certificates generated by PEM.

Enhancement

Added a capability to identify the user who changed the blackout status, date, and time.

Bug fix

Fixed an issue where a deleted custom probe was still visible in the Probe Dependency tab of Alert Templates.

Bug fix

Fixed a missing permission issue by granting the pem_agent user permission to the custom_email_template table.

Bug fix

Excluded zero-sized tables from PEM alert template largest index by table-size percentage. Also added a detailed SQL statement for this template.

Bug fix

Fixed an issue whereby the CLI attempted to call an obsolete version of the PEM API, resulting in commands failing.

Bug fix

Now, the members of the pem_user and pem_manage_efm roles can access the EFM features. The member of the pem_user and `pem_server_service_manager`role can start/stop the database service from PEM GUI.

Bug fix

Added application_name column in the session_info probe.

Bug fix

Fixed the too few arguments exception for the webhooks.

Bug fix

Resolved the issue where the User column displayed the current username logged into the PEM user interface in the chart display of the pg_hba.conf file. Now it displays the respective usernames in the pg_hba.conf file.

Bug fix

Fixed a Dashboard info not found error while opening the dashboards in the user interface.