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

Technical Alert
Postgres Enterprise Manager^Ⓡ (PEM) 7.12

WHAT’S NEW
This update is notifying you of a new software release, Postgres Enterprise Manager^Ⓡ (PEM) 7.12 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:

• Improved EDB’s Backup and Recovery Tool Integration
  • Allow the pemAgent to create a password-less SSH authentication between two linux systems. User can now choose to create the password-less SSH authentication from the database server properties dialog, and backup restore dialog.
  • Allow the pemAgent to set/override the 'archive_command' of the database server configuration using 'BART INIT' command. User can choose to set/override the 'archive_command' from the database server properties dialog.
• Accessibility Improvements
  • Added aria-label to provide an invisible label where a visible label cannot be used.
  • Added role="status" attribute to all the status messages for accessibility.
• Dark Theme (Beta)
  Limitations:
  • White background for the pie chart in the monitoring dashboards
  • All Reports (e.g. Capacity Manager, Log Analysis Expert, Postgres Expert, Tuning Wizard) will be generated using default theme only.
• Support Enable Always and Enable Replica on triggers.
• Use a 'play' icon for the Execute Query button in the Query Tool for greater consistency with other applications.
• Add an option to request confirmation before cancelling changes on a Properties dialog.

This release also includes fixes for the issues:

• Rename the context menu from 'Drop Server' to 'Remove Server'.
• Fix issue where Drop and Disconnect connection menu points are too close to each other.
• Don't quote bigints when copying them from the Query Tool results grid.
• Fix issue where the Reset button does not get enabled till all the mandatory fields are provided in the dialog.
• Ensure context menus never get hidden below the menu bar.
• Ensure the correct "running at" pgAgent is shown when a pgAgent job is executing.
• Fix an issue in the Query Tool where shortcut keys could be ignored following a query error.
• Fix the toggle case shortcut key combination.
• Ensure comments are shown in reverse engineered SQL for table partitions.
• Handle NULL values appropriately when sorting backgrid tables.
• Give appropriate error messages when the user tries to use a blank master password.
• Remove arbitrary (and incorrect) requirement that composite types must have at least two members.
• Ensure compression level is passed to pg_dump when backing up in directory format.
• Ensure the number of jobs can be specified when backing up in directory format.
• Remove the sorting of table headers with no labels.
• Suppress Enter key presses in Alertify dialogues when the come from Select2 controls to allow item selection with Enter.
• Ensure that units are respected when sorting by file size in the File dialog.
• Updated documentation for default privileges for the database objects to clarify more on the grantor.
• Ensure all messages are retained in the Query Tool from long running queries.
• Updated documentation for the delete row button that only strikeout the row instead of deleting it.
• Fix an issue where the wrong type is displayed when changing the datatype from timestamp with time-zone to timestamp without time zone.
• Updated documentation for the query tool toolbar buttons.
• Ensure that the superuser should be able to create database, as the superuser overrides all the access restrictions.
• Ensure that the superuser should be able to create role, as the superuser overrides all the access restrictions.
• Fix reverse engineering SQL issue for partitions when specifying digits as comments.
• Fix an issue where escape key not working to close the open/save file dialog.
• Fix an issue where keyboard shortcut for context menu is not working when using Firefox on CentOS7.
• Shown some text on process watcher till the initial logs are loaded.
• Fix main window tab navigation accessibility issue.
• Fix XSS issue in explain and explain analyze for table and type which contain HTML.
• Fix an issue where PEM unable to retrieve table node if the trigger is already disabled and the user clicks on Enable All.
• Fix reverse engineering SQL issue for triggers when passed a single argument to trigger function.
• Fix an issue where length and precision are not removed from table/column dialog.
• Fix an issue where the Interval data type is not displayed in the properties dialog of table/column.
• Fix 'Could not find the object on the server.' error while refreshing the check constraint.
• Fix reverse engineering SQL issue where when clause is not visible for PG/EPAS 12.
• Added statistics and storage information in reverse engineering SQL of table/column.
• Fix an issue where the inherited table name with quotes did not escape correctly.
• Fix an issue where context menu is open along with submenu and the focus is not on context menu or submenu.

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.12 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/installation-guide/latest/index.html

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