cancel
Showing results for 
Search instead for 
Did you mean: 

Technical Update for Postgres Enterprise ManagerⓇ (PEM) 7.11

 

Technical Alert/Update Information

Technical Alert Name
EDB Technical Update for Postgres Enterprise ManagerⓇ (PEM) 7.11
Product Type
Postgres Enterprise Manager
Release Date
10/24/2019
Technical Alert Details
Technical Alert
Postgres Enterprise Manager (PEM) 7.11

WHAT’S NEW
This update is notifying you of a new software release, Postgres Enterprise Manager (PEM) 7.11 from EnterpriseDB. PEM is an enterprise management tool designed to assist database administrators, system architects, and performance analysts in administering, monitoring, and tuning PostgreSQL and EDB 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:
  • Added configuration options to avoid a security risk in some environments running shell/batch scripts - The PEM Agent runs shell/batch probes and tasks under its service user account which is typically root (Administrator on Windows). The new options require system administrators to explicitly enable this functionality in the Agent configuration file if required.

    NOTE: This change may require users to update their PEM Agent configuration if they are using shell/batch tasks or probes. To return to the behaviour in prior versions of PEM:
    • On Windows, set AllowBatchJobSteps to true
    • On Linux, set batch_script_user to root
  • Query Plan Analyzer - Analyze query plans in the Graphical Explain tab in the Query Tool. It shows the time spent by each plan node and highlights misestimations between actual and plan. It also shows statistics for each plan node and each table.
This release also includes fixes for the issues:
  • User with 'super_pem_admin' role should be able to see all servers and agents. (922716)
  • Ensure backup a partition table should not backup the whole database.
  • Fix issue where backup fails for schema name that needs quoting.
  • Fix issue where export job fails when deselecting all the columns.
  • Fix an error where 'false' string is displayed when we add a new parameter in the Parameters tab, also clear the old value when the user changes the parameter name.
  • Ensure the search path is not quoted for Databases.
  • Ensure the search path is not quoted for Functions, Procedures and Trigger Functions.
  • Fix issue where VALID foreign keys show as NOT VALID in the SQL tab for tables.
  • Fixed potential error in the properties dialog for the Code tab.
  • Fixed an issue where Datetimepicker control opens when clicking on the label.
*References in brackets refer to customer issue case numbers.

End-of-Support Reminder:
We recommend you update to the most recent software version.  If you have not yet updated to the most current version, please note the end-of-support notes below*:  
  • Deprecated: PEM Package Deployment and Streaming Replication Wizard
  • Version:  7.9
  • End of Standard Support: January 31st 2020
*Additional details can be found on our website at https://www.enterprisedb.com/services-support/edb-supported-products-and-platforms#pem

TELL ME MORE
For more details, please review the EDB Postgres Enterprise Manager 7.11 documentation.
PEM Documentation

IS THIS UPDATE FOR ME?
This announcement is for EDB customers who are using, or are interested in, EDB Postgres Enterprise Manager

HOW TO GET THE UPDATE AND APPLY IT
This update is available from the EDB Postgres website (https://www.enterprisedb.com/downloads/edb-postgres-enterprise-manager).

This update is also available as RPM/DEB packages that can be downloaded from the yum.enterprisedb.com/apt.enterprisedb.com repositories respectively.To set up your credentials and gain access to the repositories, please submit a request: https://www.enterprisedb.com/repository-access-request
Windows installers are available via Stack Builder Plus.
Installation instructions can be found at:

https://www.enterprisedb.com/edb-docs/d/edb-postgres-enterprise-manager/installation-getting-started...

For other documentation in a number of different formats, please visit:

https://www.enterprisedb.com/edb-docs/p/edb-postgres-enterprise-manager/latest

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
Version history
Revision #:
2 of 2
Last update:
3 weeks ago
Updated by:
 
Contributors