Search

Release Announcement EDB Postgres Enterprise ManagerⓇ 8.0.1

Customer Portal
Customer Portal

This article was originally published on March 04, 2021

WHAT’S NEW

This update is notifying you of the new software release of Postgres Enterprise Manager (PEM) 8.0.1 from EDB. PEM combines monitoring, alerting, tuning, and database administration into a single GUI. This tool manages multiple open source PostgreSQL and/or EDB Postgres Advanced Server clusters.

This maintenance release provides fixes to issues reported by users, and does not include new features.  

A reminder of noteworthy new changes introduced for the major 8.0 release:

  • The Performance Diagnostic tool is now certified to work with PostgreSQL 10+.

NOTE: installation of the new edb_wait_states plugin for PostgreSQL is required

  • PEM Server (backend database) supports only PostgreSQL or EDB Postgres Advanced Server versions 11 or above.

This maintenance release addresses the following issues:

  • Dashboard refresh not displaying BART backups. [Support Ticket # 1046037]
  • Allow superuser name containing "-" provided during configuring configure-pem-server.sh script. [Support Ticket # 1055435]
  • Close the operating system resources properly during batch probe and command execution to avoid 'too many open files' error. [Support Ticket # 1048713]
  • Bundle pgaevent.dll in agent windows installer to suppress event message log error. [Support Ticket # 1106021]
  • Fixed the Unicode string handling support in pemAgent. [Support Ticket # 1153153]
  • Fixed the issue where BART restore was failing when the agent was not bound with the BART server. [Support Ticket # 1129454]
  • Statistics, Dependencies, and Dependants tabs are now closable. Users can add them back using the 'Add panel' option.
  • Fixed an issue where pressing the back button will show another instance of the main page inside of the Query Tool tab.
  • Added 'Count Rows' option to the partition sub tables.
  • Improve the explain plan details by showing popup instead of tooltip on clicking of the specified node.
  • Added support for expression in exclusion constraints.
  • Fixed an issue where the focus is not properly set on the filter text editor after closing the error dialog.
  • Ensure that username should be visible in the 'Connect to Server' popup when service and user name are both specified.
  • Ensure that the 'template1' database should not be visible after pg_upgrade.
  • Fixed a false error which is shown while adding a new foreign key from the table dialog when a foreign key already exists and Auto FK Index set to true.
  • Fixed an issue where the Save button is enabled by default in Macro.
  • Remove the extra line after the Manage Macros menu while clearing all macros.
  • Ensure that 'Clear All Rows' should not work if there is no existing macro available and the user does not specify any value.
  • Fixed an issue where the server is disconnected with an error message displayed if the user creates Macro with invalid SQL.
  • Ensure that the macro query result should be downloaded properly.
  • Added appropriate help message and a placeholder for letting users know about the account password expiry for Login/Group Role.
  • Ensure that dirty indicator (*) should not be visible when renaming the tabs.
  • Fixed an issue where the escape character is shown when the server/database name has some special characters.
  • Updated Flask-BabelEx to the latest.
  • Fixed an issue where schema diff doesn't show the result of compare if source schema has tables with RLS.
  • Fixed an issue where an illegal argument is showing for trigger SQL when a trigger is created for View.
  • Fixed autocomplete issue where it is not showing any suggestions if the schema name contains escape characters.
  • Fixed an issue where the state of the Save File icon does not match the dirty editor indicator.
  • Fixed an issue where the dirty indicator stays active even if all changes were undone.
  • Ensure that the rename panel should be disabled when the SQL file opened in the query tool.
  • Fixed extra parentheses issue around joins for Views.
  • Fixed accessibility issues in schema diff module.
  • Fixed an issue on refreshing files in Query Tool.
  • Fixed accessibility issues in various dialogs.
  • Fixed TypeError exception in schema diff when selected any identical object.
  • Fixed an issue where the dependencies tab showing multiple owners for the objects having shared dependencies.
  • Fixed an issue of deleting records when the user tries to delete multiple records.
  • Ensure that the user should be able to specify an older date for the account expiration of the role/user.
  • Fixed an issue where the database list in the new connection window is not visible.
  • Added informative message when there is no difference found for schema diff.
  • Fixed an issue where sequences are not created.
  • Ensure that verbose logs should be visible for Utility (Backup, Maintenance) jobs.
  • Ensure that the current value of the sequence should be ignored while comparing using schema diff.
  • Fixed an issue where strikethrough is not visible for rows selected for deletion after scrolling.
  • Fixed an issue where the user was unable to change the background color for a server.
  • Fixed an issue where utility (Backup, Maintenance) jobs are failing when the log level is set to DEBUG.

*Numbers in brackets refer to Salesforce customer issue case number

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: PostgreSQL and EDB Postgres Advanced Server 9.5
  • Versions: 9.5
  • End of Life: February 2021

NOTE: PostgreSQL and EDB Postgres Advanced Server 9.5 are not supported by Postgres Enterprise Manager.

  • Deprecated: CentOS Linux 6.x
  • Version: 6.x
  • End of Life: November 30, 2020

NOTE: CentOS 6.x is not supported by Postgres Enterprise Manager.

  • Removed: EDB ARK UI management
  • Version:  7.16

NOTE: EDB ARK cannot be managed using Postgres Enterprise Manager 7.16 and later.

  • Removed: Support on Internet Explorer 11 or less
  • Version:  7.16

NOTE: Internet Explorer 11 or less is not supported by Postgres Enterprise Manager 7.16 and later.

*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 Postgres Enterprise Manager 8.0.1 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 8.0.1 and have a database subscription purchased for:

  • Standard Subscription
  • Enterprise Subscription 
 

HOW TO GET THE UPDATE AND APPLY IT

Postgres Enterprise Manager 8.0.1 is packaged and delivered as a series of interactive installers available via StackBuilder Plus and on the EnterpriseDB website. Visit:

https://www.enterprisedb.com/advanced-downloads

This update is also available as native packages in the form of RPMs and DEBs, please visit:

https://repos.enterprisedb.com/

To request the credentials required to access EnterpriseDB repositories, please visit https://www.enterprisedb.com/repository-access-request

Documentation is provided on the EnterpriseDB website. Visit: https://www.enterprisedb.com/edb-docs/

TROUBLESHOOTING 

If you experience any problems around the installation, migration, upgrade, or general use of your EDB software please contact our Technical Support teams. We can be reached at https://support.enterprisedb.com, but we’re also available 24 x 7 via email and phone at the details below:

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

 

Was this article helpful?

0 out of 0 found this helpful