Version 8.0.0 v8

New features, enhancements, bug fixes, and other changes in PEM 8.0.0 include:

TypeDescriptionID
New FeatureSecurity Best Practices: Securing your deployment documentation is available from our docs website. It will help you to setup PEM in a secure way to minimize the risk of vulnerabilities.PEM-3802, PEM-3805
New FeatureWebhooks: You can now use PEM to send event based notifications to webhook endpoints like third party systems or partner applications.PEM-3819
EnhancementPerformance Diagnostics: Use the Performance Diagnostic tool with PostgreSQL 10 or later versions after installing 'edb_wait_states' plugin.NA
EnhancementPEM Backend Database: The PEM Server (backend database) supports only PostgreSQL or EDB Postgres Advanced Server versions 11 or later.NA
EnhancementEnhanced Alerting: You can now replace alert placeholders inside the script and also can view more informative and contextual alert details. [Support Ticket #1051538, #891377]PEM-3612, PEM-3613, PEM-2501
EnhancementEnhanced BART Integration: Configure 'bart_socket_name' and also parameters such as '--checksum-algorithm' and '--disable-checksum' through PEM.PEM-3669
EnhancementYou can use the Macros feature in the Query tool.#1402
EnhancementYou can use the trigger function under the respective trigger node.#2519
EnhancementYou can download the utility files at the client side using Storage Manager.#3318
EnhancementYou can use the open Query tool tab to change the database connection.#3794
EnhancementYou can rename the Query tool and Debugger tab.#4230
EnhancementYou can ignore the owner while comparing the objects through Schema diff tool.#5200
EnhancementImproved installation and upgrade guide as per customer feedback. [Support Ticket # 1101462]PEM-3808
Bug FixDocumented that while configuring the pem server, certificates must be present in data directory of backend database server in the installation guides. [Support Ticket # 729238]PEM-672
Bug FixConnections not getting released when the user disconnects the database server. [Support Ticket #969833]PEM-3184
Bug FixFixed an issue where BART integration isn't working, when BART is installed at custom location. [Support Ticket # 1088574]PEM-3737
Bug FixDo not include detailed alert information while sending SNMP traps. [Support Ticket #1069206, #1115277]PEM-3791
Bug FixTwo database connections made for failed login attempts which result in locking the user profile. [Support Ticket #1103288]PEM-3816
Bug FixPackage deployment and streaming replication deprecation warning is added in Upgrade and Migration Guide. [Support Ticket #1021617]PEM-3799
Bug FixEnsure that some fields should be disabled for the trigger in edit mode.#4639
Bug FixAdded a useful message when the explain plan is not used and empty.#4806
Bug FixFile extension is stripped on renaming a file.#4855
Bug FixEnsure that the 'ctrl + a' shortcut does not move the cursor in the SQL Editor.#5131
Bug FixFixed an issue where schema diff is showing identical tables as different due to default vacuum settings.#5826
Bug FixFixed reverse engineering SQL where parenthesis is not properly arranged for View/MView definition.#5830
Bug FixFixed 'can't execute an empty query' message if the user changes the option of Auto FK Index.#5835
Bug FixFixed an issue where the server is not able to connect using the service.#5841
Bug FixEnsure that query history should be listed by date/time in descending order.#5842
Bug FixFixed an issue where the 'PARALLEL UNSAFE' option is missing from reverse engineering SQL of function/procedure.#5843
Bug FixFixed an issue where 'Rows X' column values were not visible properly for Explain Analyze in Dark theme.#5853
Bug FixEnsure that the user should be able to change the start value of the existing sequence.#5855
Bug FixEnsure that search object functionality works with case insensitive strings.#5858
Bug FixFixed invalid literal issue when fetching dependencies for Materialized View.#5882
Bug FixFixed an issue where the user is unable to change the macro name.#5885
Bug FixFixed an issue where the suffix for Toast table size is not visible in the Statistics tab.#5895
Bug FixEnsure that macros should be run on the older version of Safari and Chrome.#5911
Bug FixFixed an issue where a mismatch in the value of 'Estimated row' for functions.#5914
Bug FixFixed an issue where non-closable tabs are getting closed.#5923
Bug FixEnsure that folder rename should work properly in Storage Manager.#5943
Bug FixFixed an issue where a long file name is not visible on the process watcher dialog.#5950
Bug FixFixed an issue where connection to the server is on wait state if a different user is provided.#5953
Bug FixEnsure that Grant Wizard should include foreign tables.#5959
Bug FixFixed an issue where the debugger's custom tab title did not apply when opened in the new browser tab.#5974
Bug FixFixed an issue where the dynamic tab title has not applied the first time for the debugger panel.#5978
Bug FixAdded the appropriate server icon based on the server type in the new connection dialog.#5983
Bug FixFixed an issue where the process watcher dialog throws an error for the database server which is already removed.#5985