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, setAllowBatchJobStepstotrue
On Linux, setbatch_script_usertoroot
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