Version 8.1.0 v8
New features, enhancements, bug fixes, and other changes in PEM 8.1.0 include:
| Type | Description | ID |
|---|---|---|
| New Feature | PGD (Bi-Directional Replication) dashboards and probes to monitor status and activities for admin, nodes, and groups. For example, if replication starts falling behind, the administrator is alerted and can take proactive action. See Monitoring EDB Postgres Distributed. | PEM-3893 |
| New Feature | Kerberos security and authentication for PEM Web Client through GSSAPI or Active Directory Domain Services. Prevent password interception and prove identity required by highly regulated industries. [Support Ticket #1044678] See Configuring the PEM server to use Kerberos authentication. | PEM-3559 |
| New Feature | Entity-Relationship Diagram (ERD) design tool that graphically represents database tables, columns, and interrelationships. Conceptualize database design before building or reverse engineering. See The ERD Tool. | #6397 |
| New Feature | Logical replication support to manage publications and subscriptions for core logical replication in Postgres. Send incremental changes across different database versions or platforms. | #5912 |
| New Feature | Quick Search option to locate features and relevant help articles with a guided user experience. Type three characters to start displaying matching possibilities. | #6148 |
| Enhancement | EDB Postgres Extended Server (used by PGD Enterprise) certified for monitoring and administration. | PEM-4015 |
| Enhancement | Configuration parameters for Audit Manager, Tuning Wizard, and Log Manager no longer require a restart of the database. [Support Ticket #649078] | PEM-795, PEM-1465, PEM-3829 |
| Enhancement | Manage the privileges for a package node with Grant Wizard. | #1591 |
| Enhancement | Maximize/restore the window for the properties dialog. | #4064 |
| Enhancement | While examining the group role, display the login roles. | #5404 |
| Enhancement | Set automatic width of columns by content size in the data output window. | #5954 |
| Enhancement | Support for cache busting webpack chunk files. | #5477 |
| Enhancement | SSL support for creating a subscription. | #6201 |
| Enhancement | Support for the creation of Nested Table and Varying Array Type for Advanced Server. | #6407 |
| Enhancement | Comment column in the properties panel for View and Materialized View collection node. | #6416 |
| Bug Fix | Process the alert if there is an error while processing alert detailed information. [Support Ticket #1201865] | PEM-1032 |
| Bug Fix | Remove the obsolete data of a deleted database from pemhistory on the next purge. Support Ticket #1055978] | PEM-3810 |
| Bug Fix | Flapping does not end when at least a one-time alert triggered during the flapping period. [Support Ticket #1165155] | PEM-3966 |
| Bug Fix | Getting 404 for REST API of agent probe history. [Support Ticket #1219795] | PEM-3974 |
| Bug Fix | The "A user expires in N days" alert template code failing on Postgres. [Support Ticket #1235289] | PEM-3988 |
| Bug Fix | Check for sslutils for version 1.3 in the configure script. [Support Ticket #1284690] | PEM-4042 |
| Bug Fix | Correct OID for binding variable "downObjects" for AgentsDown and ServersDown alerts. [Support Ticket #1300113] | PEM-4073 |
| Bug Fix | Read the log configuration data from the system probe tables for the selected servers in the Log Manager. [Support Ticket #1262817] | PEM-4029 |
| Bug Fix | Skip the PEM Server registration when installing using only a web server option to avoid duplicate entries in the server listing. [Support Ticket #1210935] | PEM-3977 |
| Bug Fix | Alignment issues under preferences for the German language. | #4014 |
| Bug Fix | Issue with renaming the database by another user. | #4203 |
| Bug Fix | Drag and drop object is not correct in CodeMirror for properties dialog. | #4436 |
| Bug Fix | Adding/updating records fails if the table name contains a percent sign. | #4438 |
| Bug Fix | Ensure that autovacuum and analyze scale factors should be editable with more than two decimals. | #4784 |
| Bug Fix | % displayed twice in Explain Analyze for query and table. | #4847 |
| Bug Fix | Rename text 'table' to 'relation' in the Statistics tab for Explain Analyze. | #4849 |
| Bug Fix | Properties tab for Collection Nodes is unresponsive after switching the tabs. | #4959 |
| Bug Fix | Save button is enabled for functions/procedures by default when opening the Properties dialog. | #5073 |
| Bug Fix | Hanging symlinks in a directory causes Select file dialog to break. | #5119 |
| Bug Fix | Ensure that the Query tool tab should be closed after server disconnection when auto-commit/auto-rollback is set to false. | #5519 |
| Bug Fix | Data is displayed in the wrong order when executing the query repeatedly. | #5555 |
| Bug Fix | Ensure that cell content is auto-selected when editing the cell data. | #5810 |
| Bug Fix | Ensure that SQL formatter should not add extra tabs and format the SQL correctly. | #5869 |
| Bug Fix | Shortcut keys are not working with manage macro. | #5908 |
| Bug Fix | Encoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character. | #6018 |
| Bug Fix | Ensure that the user should not change the connection when a long query is running. | #6082 |
| Bug Fix | Flickering issue with the input box on check constraints. | #6106 |
| Bug Fix | User is unable to update column-level privileges from the security tab. | #6117 |
| Bug Fix | Ensure that the user should be able to kill the session from Dashboard if the user has a 'pg_signal_backend' role. | #6159 |
| Bug Fix | Cursor shifts its focus to the wrong window for all the Query tool related model dialogs. | #6161 |
| Bug Fix | Correct the syntax for 'CREATE TRIGGER', use 'EXECUTE FUNCTION' instead of 'EXECUTE PROCEDURE' from Postgres v11 onwards. | #6220 |
| Bug Fix | User is not able to create the subscription. | #6230 |
| Bug Fix | Ensure that SQL formatter should not use tab size if 'Use spaces?' set to false. | #6233 |
| Bug Fix | Ensure that the view/edit data panel should not be opened for unsupported nodes using the keyboard shortcut. | #6206 |
| Bug Fix | User is unable to create a subscription if the host/IP address for connection is 127.0.0.1. | #6253 |
| Bug Fix | Ensure that proper error messages should be shown on the properties and statistics tab in case of insufficient privileges for a subscription. | #6259 |
| Bug Fix | 'Create Slot' option is disabled in case of the same IP/host provided but the port is different. | #6260 |
| Bug Fix | User is not able to change the connection in the Query tool when any SQL file is opened. | #6272 |
| Bug Fix | Ensure that the strings in the LDAP auth module are translatable. | #6274 |
| Bug Fix | Schema diff shows the wrong SQL when comparing triggers with different when clauses. | #6281 |
| Bug Fix | Ensure that the template database should be visible while creating the database. | #6286 |
| Bug Fix | String index out of range error where the dependent tab is in focus and selecting any publication or table. | #6292 |
| Bug Fix | Procedure creation failed when providing the Volatility option. | #6293 |
| Bug Fix | Dependent tab threw an error when selecting any Login/Group role. | #6294 |
| Bug Fix | While selecting the row which was deleted just before the selection operation. | #6306 |
| Bug Fix | Incorrect values were visible in the Dependents tab for publication. | #6307 |
| Bug Fix | Copy/paste rows in view data paste the wrong value for Boolean type. | #6312 |
| Bug Fix | Ensure that the primary key should be visible properly in the Table dialog. | #6316 |
| Bug Fix | Ensure that toggle buttons are accessible by most screen readers. | #6317 |
| Bug Fix | Ensure that the grantor name should be visible properly for the Security tab in the Table dialog. | #6323 |
| Bug Fix | Ensure that the file format for the storage manager should be 'All files' and for other dialogs, it should remember the last selected format. | #6325 |
| Bug Fix | Ensure that while comparing domains check function dependencies should be considered in schema diff. | #6327 |
| Bug Fix | Wrong SQL is showing for the child partition tables. | #6329 |
| Bug Fix | Sizing issue of help dialog for Query tool when open in the new browser tab. | #6333 |
| Bug Fix | CSV download quotes the numeric columns. | #6341 |
| Bug Fix | Cannot unpack non-iterable response object error when selecting any partition. | #6344 |
| Bug Fix | Ensure that we should not allow opening external files that are dragged into it. | #6355 |
| Bug Fix | Users are unable to see data of the partitions using the View/Edit data option. | #6375 |
| Bug Fix | A connection warning should be displayed when the user clicks on Explain or Explain Analyze and the database server is disconnected from the browser tree. | #6376 |
| Bug Fix | Schema diff does not create DROP DEFAULT statements for columns. | #6377 |
| Bug Fix | Foreign data wrapper properties are not visible if the host option contains two host addresses. | #6379 |
| Bug Fix | Ensure that Backup and Restore should work on shared servers. | #6385 |
| Bug Fix | The filter 'Include/Exclude By Selection' is not working for null values. | #6392 |
| Bug Fix | Ensure that the user should not be able to add duplicate panels. | #6399 |
| Bug Fix | Current debug line is not visible in the 'Dark' theme. | #6409 |
| Bug Fix | Duplicate columns are visible in the browser tree, which is owned by two sequences. | #6413 |
| Bug Fix | Help message was not displaying correctly on the Login/Group role. | #6414 |
| Bug Fix | Query editor is not being closed if the user clicks on the 'Don't Save' button. | #6417 |
| Bug Fix | File dialog shows incorrect files for the selected file types. | #6443 |
| Bug Fix | Duplicate SQL issue for tables with more than one partition. | #6478 |