Version 8.0.0 v8
New features, enhancements, bug fixes, and other changes in PEM 8.0.0 include:
| Type | Description | ID |
|---|---|---|
| New Feature | Security 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 Feature | Webhooks: You can now use PEM to send event based notifications to webhook endpoints like third party systems or partner applications. | PEM-3819 |
| Enhancement | Performance Diagnostics: Use the Performance Diagnostic tool with PostgreSQL 10 or later versions after installing 'edb_wait_states' plugin. | NA |
| Enhancement | PEM Backend Database: The PEM Server (backend database) supports only PostgreSQL or EDB Postgres Advanced Server versions 11 or later. | NA |
| Enhancement | Enhanced 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 |
| Enhancement | Enhanced BART Integration: Configure 'bart_socket_name' and also parameters such as '--checksum-algorithm' and '--disable-checksum' through PEM. | PEM-3669 |
| Enhancement | You can use the Macros feature in the Query tool. | #1402 |
| Enhancement | You can use the trigger function under the respective trigger node. | #2519 |
| Enhancement | You can download the utility files at the client side using Storage Manager. | #3318 |
| Enhancement | You can use the open Query tool tab to change the database connection. | #3794 |
| Enhancement | You can rename the Query tool and Debugger tab. | #4230 |
| Enhancement | You can ignore the owner while comparing the objects through Schema diff tool. | #5200 |
| Enhancement | Improved installation and upgrade guide as per customer feedback. [Support Ticket # 1101462] | PEM-3808 |
| Bug Fix | Documented 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 Fix | Connections not getting released when the user disconnects the database server. [Support Ticket #969833] | PEM-3184 |
| Bug Fix | Fixed an issue where BART integration isn't working, when BART is installed at custom location. [Support Ticket # 1088574] | PEM-3737 |
| Bug Fix | Do not include detailed alert information while sending SNMP traps. [Support Ticket #1069206, #1115277] | PEM-3791 |
| Bug Fix | Two database connections made for failed login attempts which result in locking the user profile. [Support Ticket #1103288] | PEM-3816 |
| Bug Fix | Package deployment and streaming replication deprecation warning is added in Upgrade and Migration Guide. [Support Ticket #1021617] | PEM-3799 |
| Bug Fix | Ensure that some fields should be disabled for the trigger in edit mode. | #4639 |
| Bug Fix | Added a useful message when the explain plan is not used and empty. | #4806 |
| Bug Fix | File extension is stripped on renaming a file. | #4855 |
| Bug Fix | Ensure that the 'ctrl + a' shortcut does not move the cursor in the SQL Editor. | #5131 |
| Bug Fix | Fixed an issue where schema diff is showing identical tables as different due to default vacuum settings. | #5826 |
| Bug Fix | Fixed reverse engineering SQL where parenthesis is not properly arranged for View/MView definition. | #5830 |
| Bug Fix | Fixed 'can't execute an empty query' message if the user changes the option of Auto FK Index. | #5835 |
| Bug Fix | Fixed an issue where the server is not able to connect using the service. | #5841 |
| Bug Fix | Ensure that query history should be listed by date/time in descending order. | #5842 |
| Bug Fix | Fixed an issue where the 'PARALLEL UNSAFE' option is missing from reverse engineering SQL of function/procedure. | #5843 |
| Bug Fix | Fixed an issue where 'Rows X' column values were not visible properly for Explain Analyze in Dark theme. | #5853 |
| Bug Fix | Ensure that the user should be able to change the start value of the existing sequence. | #5855 |
| Bug Fix | Ensure that search object functionality works with case insensitive strings. | #5858 |
| Bug Fix | Fixed invalid literal issue when fetching dependencies for Materialized View. | #5882 |
| Bug Fix | Fixed an issue where the user is unable to change the macro name. | #5885 |
| Bug Fix | Fixed an issue where the suffix for Toast table size is not visible in the Statistics tab. | #5895 |
| Bug Fix | Ensure that macros should be run on the older version of Safari and Chrome. | #5911 |
| Bug Fix | Fixed an issue where a mismatch in the value of 'Estimated row' for functions. | #5914 |
| Bug Fix | Fixed an issue where non-closable tabs are getting closed. | #5923 |
| Bug Fix | Ensure that folder rename should work properly in Storage Manager. | #5943 |
| Bug Fix | Fixed an issue where a long file name is not visible on the process watcher dialog. | #5950 |
| Bug Fix | Fixed an issue where connection to the server is on wait state if a different user is provided. | #5953 |
| Bug Fix | Ensure that Grant Wizard should include foreign tables. | #5959 |
| Bug Fix | Fixed an issue where the debugger's custom tab title did not apply when opened in the new browser tab. | #5974 |
| Bug Fix | Fixed an issue where the dynamic tab title has not applied the first time for the debugger panel. | #5978 |
| Bug Fix | Added the appropriate server icon based on the server type in the new connection dialog. | #5983 |
| Bug Fix | Fixed an issue where the process watcher dialog throws an error for the database server which is already removed. | #5985 |