This article was originally published on October 27, 2018
Technical Update
Postgres Enterprise ManagerⓇ (PEM) 7.5
WHAT’S NEW
This update is notifying you of a new software release Postgres Enterprise ManagerⓇ (PEM) 7.5. 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 for monitoring PostgreSQL 11 & EDB Postgres Advanced Server 11
-
Added a geometry viewer that can render PostGIS data on a blank canvas or various map sources - Added a geometry viewer in the query tool, which is capable of rendering the PostGIS data on a blank canvas or various map sources.
-
Support for PostgreSQL 11 & EDB Postgres Advanced Server 11 as the backend database server for the PEM Server
-
Use of PgBouncer as a connection pooler to increase the number of database servers that a single PEM instance can monitor - PgBouncer (1.9.0+) can be used as a connection pooler between the PEM backend database server and the PEM Agents. PEM Agents can use a single database user to connect to the PEM database server instead of dedicated database users, as was the practice in earlier PEM releases.
-
Exclude specific mount points from the disk-space probe - Exclude selected mount points explicitly for the disk-space probe on a specific host. (PEM-796)
-
Save the treeview state periodically, and restore it automatically - Save the treeview state periodically, and restore it automatically when re-connecting the database server, or refreshing the browser page
-
Added shortcuts for View Data and the Query tool to the Browser header bar - Added shortcuts for View Data and Query tool to the Browser header bar to quick access.
-
Added optional data point markers and mouse-over tooltips to display values on graphs on the real-time dashboards - Added optional data point markers and mouse-over tooltips to display the values on the graphs on the real-time dashboards, which can be enabled/disabled from the preferences dialog.
This release also includes fixes for the issues:
-
Can't debug function and procedure in a package using a non-superuser role (#PEM-724, #569062)
-
Fix support for the CLOB datatype in EPAS (PEM-918, #761853)
-
Allow to enter the floating values for the threshold fields in Alerts configuration window (PEM-1004, #775364)
-
User can not save password when connecting to server (PEM-1330 , #792298)
-
Allow to install on PostgreSQL/EDB Postgres Advanced Server version 9.4 or lesser (PEM-1350, #796149)
-
Release the connections for the connected servers on logout (PEM-1431, #807009)
-
Fix auto scrolling issue in debugger on step in and step out (#779956)
-
Purge connections from the cache on logout (#807009)
-
Ensure that refresh button on the real-time dashboard at database level should refresh the table
-
Fix handling of backslashes in the edit grid
-
Ensure queries are no longer executed when real-time dashboards are closed
-
Fix logic around validation and highlighting of Sort/Filter in the Query Tool
-
Ensure auto-complete works for objects in schemas other than public and pg_catalog
-
Ensure changes to Query Tool settings from the Preferences dialogue are applied before executing queries
-
Swap the Schema and Schemas icons and Catalog and Catalogs icons that had been used the wrong way around
-
Rename the 'SQL Editor' section of the Preferences to 'Query Tool' as it applies to the whole tool, not just the editor
-
Cleanup files for the in-active sessions periodically
-
Case sensitive issue for column lag_MB in probe Standby servers lag behind the master by size(MB)
TELL ME MORE
For more details, please review the EDB Postgres Enterprise Manager 7.5 documentation:
https://www.enterprisedb.com/resources/product-documentation//document_category%3A2308%7Cversions%3A3280?search=&filter_field=
IS THIS UPDATE FOR ME?
This announcement is for EDB customers who are using, or are interested in, EDB Postgres Enterprise Manager 7.5 or have a database subscription purchased for:
-
Postgres Enterprise Manager 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