This article was originally published on January 16, 2019
Technical Update
Postgres Enterprise ManagerⓇ (PEM) 7.6
This update is notifying you of a new software release, Postgres Enterprise ManagerⓇ (PEM) 7.6. PEM is an enterprise management tool designed to assist database administrators, system architects, and performance analysts in administering, monitoring, and tuning PostgreSQL and EnterpriseDB Postgres Advanced Server database servers. PEM is architected to manage and monitor anywhere from a handful, to hundreds of servers from a single console, allowing complete and remote control over all aspects of your databases.
Highlights of this release includes:
-
Support added for the performance diagnostic (edb_wait_stat) plugin for EDB Postgres Advanced ServerⓇ - Analyze the wait statistics of the database server for any time range, and diagnose query performance.
-
Users are now able to delete Server Groups in PEM (#737536) - Allow the user to delete the server groups.
-
Allow query plans to be downloaded as an SVG file (#816621) - Graphical Explain Plans of a query can be downloaded as an SVG file in the query editor.
-
Ability to drop multiple objects at once from the collection Properties panel - Allow dropping/deleting multiple objects at once from the collection Properties panel.
-
Added 'Stop Process' button to cancel the process running for the external utilities used by Backup, Restore, Maintenance, and Import-Export - Allow user to terminate a process running for the external utilities used by the Backup/Restore/Maintenance/Import/Export functionalities from the process watcher notification/panel.
-
Migrate from Bootstrap 3 to Bootstrap 4
-
Support added to sslutils to work with OpenSSL 1.1+
This release also includes fixes for the issues:
-
Fix the HTTP Trace/track vulnerability in default PEM config (#784345, #818383)
-
Fix an issue with the pgAdmin create script for the function wrapped with edbwrap (#796491, #826396)
-
Connect to web server error for server level charts (#815806)
-
Monitor EFM with error: Failed to parse EFM JSON file (#826197)
-
Display EFM Status in streaming replication dashboard (#826397)
-
Ensure that Utilities (Backup/Restore/Maintenance/Import-Export) should not be started if binary path is wrong
-
Ensure previous notices are not removed from the Messages tab in the Query Tool if an error occurs during query execution
-
Allow the selection order to be preserved in the Select2 control to fix column ordering in data Import/Export
-
Increase the size of the resize handle of the edit grid text pop-out
-
Fix handling of array types as inputs to the debugger
-
Fix an issue that could cause the Query Tool to fail to render
-
Further improvements to treeview restoration
To be deprecated from the next release:
-
Bitrock installers on Linux will be deprecated from the next release and will be replaced by native packages RPM and Debian for Linux from the next release. Bitrock installers on Windows will still be available.
TELL ME MORE
For more details, please review the EDB Postgres Enterprise Manager 7.6 documentation:
https://www.enterprisedb.com/edb-docs/p/edb-postgres-enterprise-manager/latest
IS THIS UPDATE FOR ME?
This announcement is for EDB customers who are using, or are interested in, EDB Postgres Enterprise Manager 7.6 or have a database subscription purchased for:
-
Postgres Enterprise Manager v7.5, v7.4.x, v7.3.x, v7.2.x, v7.1.x, v7.0.x, v6.0.x, v5.0.x
-
EDB Postgres Advanced Server 11.0.x, 10.0.x, 9.6.x
-
Postgres Plus Advanced Server 9.5.x, 9.4.x, 9.3.x
HOW TO GET THE UPDATE AND APPLY IT
This update is available from the EDB Postgres website (https://www.enterprisedb.com/advanced-downloads) or via Stack Builder Plus.
This update is also available as a RPM package that can be downloaded from the yum.enterprisedb.com repository. To set up your credentials and gain access to the yum repository, please submit a request: https://www.enterprisedb.com/repository-access-request
If you are installing a new system, please review the Installation Guide for more details (HTML - https://www.enterprisedb.com/docs/en/7.5/PEM_Inst_Guide_v7.5/toc.html or PDF - https://get.enterprisedb.com/docs/PEM_Installation_Guide_v7.5.pdf
If you are upgrading from a previous release, please review the Upgrade Guide for more details (HTML - https://www.enterprisedb.com/docs/en/7.5/PEM_Upgrade_Migration_v7.5/toc.html or PDF - https://get.enterprisedb.com/docs/PEM_Upgrade_and_Migration_Guide_v7.5.pdf)
For more information, please review the PEM Getting Started Guide (HTML - https://www.enterprisedb.com/docs/en/7.5/PEM_GSG_v7.5/toc.html or PDF - https://get.enterprisedb.com/docs/PEM_Getting_Started_Guide_v7.5.pdf)
TROUBLESHOOTING
If you experience any problems installing the new software please contact Technical Support at:
Email: support@enterprisedb.com
Phone: US: +1-732-331-1320 or 1-800-235-5891
UK: +44-2033719820
Brazil: +55-2139581371
India: +91-20-66449612