This article was originally published on October 06, 2020
This update is notifying you of the new software release of Postgres Enterprise Manager (PEM) 7.16 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.
- Display all the events and error messages in the graph tooltip for EDB Backup and Recovery Tool (BART) activities
- Allow scheduling alert blackouts on servers and agents (901007)
Other highlights of this PEM release include:
| Features | Benefits |
|
Enhanced BART integration
|
More efficient management and monitoring of EDB Backup and Recovery Tool (BART) via the PEM console |
|
Enhanced EFM integration
|
Greater management and insight of EDB Failover Manager (EFM) via the PEM console |
|
Auto discovery of server clusters on Debian platforms |
Quickly locate database servers that reside on a monitored system |
|
Extend the REST API on alerts states for agents, servers and databases
|
Better third-party integration |
Other features include:
- Use the same agent-id on agent registration using '--force-registration' and regenerate the certificates. (695978)
- Added documentation of defining and monitoring Postgres instances on Amazon EC2 and RDS. (1060981)
- Added SQL Formatter support in Query Tool.
- Added a new button to the Query Tool toolbar to open a new Query Tool window.
- Modified schema diff tool to compare two databases instead of two schemas.
- Added High Contrast (Beta) theme support.
- Warn the user when connecting to a server that is older than PEM supports.
- Removed the EDB ARK UI management.
This release also includes fixes for the following issues:
- Generate new session-id on successful login & login to fix the “Session Fixation” security issue. (1035935)
- Transaction ID or timestamp must be provided during BART restore point-in time recovery operation. (#1067393)
- Allow to take an incremental backup from a parent backup of ‘tar.gz’ format. (1059420)
- Fixed the 'MIB' file validation issue. (900679)
- Updated the “Linux Installation Guide” to point to the correct EPEL repository for each platform. (1025602)
- Updated the Boost version to avoid segfault in the pemWorker binary. (999681)
- Use the correct local time zone information of the data points in monitoring dashboard line charts. (1023887)
- Fixed potential data type migration problem when upgrading PEM Server to PG v.12. (1044052)
- Fixed configure script issue for Google Cloud instance running RHEL7.
- Fixed the issue related to parenthesis around SQL conditions in the query and also fixed reverse engineering SQL where parenthesis is not properly arranged for View and Materialized View definition. (315838)
- Fixed the pemAgent crash issue by updating the Boost library for each platform. (999681)
- Fixed current and previous alert state related issue during alert script execution when alert state gets clear. (1078828)
- Fixed security issue related to information exposed in Server response header. (1035935)
- Fixed the XSS security issue in the Capacity Manager report. (1035935)
- Fixed the security issue related to PEM configure script where sensitive information should not be logged in the log file. (1035935)
- Fixed security issue related to secure flag for the session cookies. (1035935)
- Fixed security issue related to Content Security Policy (CSP) configuration. (1035935)
- Fixed security issue related to directory listing. (1035935)
- Fixed security issue related to HTTP Strict Transport Security (HSTS) in server response header. (1035935)
- Ensure that the original file format should be retained when saving the same file in SQL editor.
- Added missing comments in reverse engineering SQL for each column of a view.
- Fixed an issue where debugger doesn't work if the search path is set other than 'public'.
- Ensure that schema names starting with 'pg' should be visible in the browser tree when standard_conforming_strings is set to off.
- Fixed SSH tunnel hang issue when the user tries to disconnect the server.
- Fixed an issue where the user is not able to insert the data if the table and columns name contains special characters.
- Fixed an issue where the user is not able to save the new row if the table is empty.
- Fixed save button enable issue when focusing in and out of numeric input field.
- Adjusted the height of the jobstep code block to use maximum space.
- Ensure that the Dictionaries drop-down shows all the dictionaries in the FTS configuration dialog.
- Fixed an issue where copying and pasting a cell with multiple line data will result in multiple rows.
- Ensure that the referenced table should be displayed on foreign key constraints.
- Fixed an issue where conversion of bytea to the binary string results in an error.
- Fixed reverse engineered SQL for partitions when storage parameters are specified.
- Fixed an issue where the entire logs is in red text when the user runs backup and restore.
- Ensure that the user will be able to modify the start value of the Identity column.
- Ensure that RLS Policy node should be searchable using search object.
- Modified the 'Commit' and 'Rollback' query tool button icons.
- Added missing dependencies/dependent and corrected some wrongly identified.
- Fixed an issue where the error message does not have a close button on utility dialogs.
- Fixed CSRF errors when PEM opened in an iframe on Safari browser.
- Fixed text color issue in Explain Analyze for the dark theme.
- Fixed issue where the user was not able to update policy if the policy is created with space.
- Added the 'ORDER BY' clause for the privileges type to fix schema diff issue.
- Fixed an issue when comparing the table with a trigger throwing error in schema diff.
- Corrected DROP SQL syntax for catalog.
- Fixed an issue where AJAX call continues to fire even after disconnecting the database server.
- Ensure that the user should be able to drop the database even if it is connected.
- Clarify some of the differences when running in server mode in documentation.
- Resolve schema diff dependencies by selecting the appropriate node automatically and maintain the order in the generated script.
- Fixed some accessibility issues.
- Update the description of GIN and GiST indexes in the documentation.
- Fixed an issue where --load-server does not allow loading connections that use pg_services.
- Fixed incorrect reverse engineering SQL for foreign key when creating a table.
- Fixed an issue where schema diff is not working when providing the options to Foreign Data Wrapper, Foreign Server, and User Mapping.
- Fixed SQL for Row Level Security which is incorrectly generated.
- Fixed an issue in the query tool when columns are having the same name as JavaScript object internal functions.
- Fixed string indices must be an integer issue for PostgreSQL < 9.3.
- Remove illegal argument from trigger function in trigger DDL statement.
- Fixed excessive CPU usage by stopping the indefinite growth of the graph dataset.
- Fixed an issue where clicking on the 'Generate script' button shows a forever spinner due to pop up blocker.
- Ensure that the 'CREATE SCHEMA' statement should be present in the generated script if the schema is not present in the target database.
- Fixed an issue where custom sequences are not visible when show system objects are set to false.
*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*:
- 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 7.16 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 7.16 and have a database subscription purchased for:
-
Standard Subscription
-
Enterprise Subscription
HOW TO GET THE UPDATE AND APPLY IT
Postgres Enterprise Manager 7.16 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 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