EDB Technical Update for Postgres Enterprise ManagerⓇ (PEM) 7.11

This article was originally published on October 24, 2019

• 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.

• 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.

• Deprecated: PEM Package Deployment and Streaming Replication Wizard
• Version:  7.9
• End of Standard Support: January 31st 2020