Version 8.1.0 v8

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

TypeDescriptionID
New FeaturePGD (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 FeatureKerberos 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 FeatureEntity-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 FeatureLogical replication support to manage publications and subscriptions for core logical replication in Postgres. Send incremental changes across different database versions or platforms.#5912
New FeatureQuick Search option to locate features and relevant help articles with a guided user experience. Type three characters to start displaying matching possibilities.#6148
EnhancementEDB Postgres Extended Server (used by PGD Enterprise) certified for monitoring and administration.PEM-4015
EnhancementConfiguration 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
EnhancementManage the privileges for a package node with Grant Wizard.#1591
EnhancementMaximize/restore the window for the properties dialog.#4064
EnhancementWhile examining the group role, display the login roles.#5404
EnhancementSet automatic width of columns by content size in the data output window.#5954
EnhancementSupport for cache busting webpack chunk files.#5477
EnhancementSSL support for creating a subscription.#6201
EnhancementSupport for the creation of Nested Table and Varying Array Type for Advanced Server.#6407
EnhancementComment column in the properties panel for View and Materialized View collection node.#6416
Bug FixProcess the alert if there is an error while processing alert detailed information. [Support Ticket #1201865]PEM-1032
Bug FixRemove the obsolete data of a deleted database from pemhistory on the next purge. Support Ticket #1055978]PEM-3810
Bug FixFlapping does not end when at least a one-time alert triggered during the flapping period. [Support Ticket #1165155]PEM-3966
Bug FixGetting 404 for REST API of agent probe history. [Support Ticket #1219795]PEM-3974
Bug FixThe "A user expires in N days" alert template code failing on Postgres. [Support Ticket #1235289]PEM-3988
Bug FixCheck for sslutils for version 1.3 in the configure script. [Support Ticket #1284690]PEM-4042
Bug FixCorrect OID for binding variable "downObjects" for AgentsDown and ServersDown alerts. [Support Ticket #1300113]PEM-4073
Bug FixRead the log configuration data from the system probe tables for the selected servers in the Log Manager. [Support Ticket #1262817]PEM-4029
Bug FixSkip 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 FixAlignment issues under preferences for the German language.#4014
Bug FixIssue with renaming the database by another user.#4203
Bug FixDrag and drop object is not correct in CodeMirror for properties dialog.#4436
Bug FixAdding/updating records fails if the table name contains a percent sign.#4438
Bug FixEnsure 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 FixRename text 'table' to 'relation' in the Statistics tab for Explain Analyze.#4849
Bug FixProperties tab for Collection Nodes is unresponsive after switching the tabs.#4959
Bug FixSave button is enabled for functions/procedures by default when opening the Properties dialog.#5073
Bug FixHanging symlinks in a directory causes Select file dialog to break.#5119
Bug FixEnsure that the Query tool tab should be closed after server disconnection when auto-commit/auto-rollback is set to false.#5519
Bug FixData is displayed in the wrong order when executing the query repeatedly.#5555
Bug FixEnsure that cell content is auto-selected when editing the cell data.#5810
Bug FixEnsure that SQL formatter should not add extra tabs and format the SQL correctly.#5869
Bug FixShortcut keys are not working with manage macro.#5908
Bug FixEncoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character.#6018
Bug FixEnsure that the user should not change the connection when a long query is running.#6082
Bug FixFlickering issue with the input box on check constraints.#6106
Bug FixUser is unable to update column-level privileges from the security tab.#6117
Bug FixEnsure that the user should be able to kill the session from Dashboard if the user has a 'pg_signal_backend' role.#6159
Bug FixCursor shifts its focus to the wrong window for all the Query tool related model dialogs.#6161
Bug FixCorrect the syntax for 'CREATE TRIGGER', use 'EXECUTE FUNCTION' instead of 'EXECUTE PROCEDURE' from Postgres v11 onwards.#6220
Bug FixUser is not able to create the subscription.#6230
Bug FixEnsure that SQL formatter should not use tab size if 'Use spaces?' set to false.#6233
Bug FixEnsure that the view/edit data panel should not be opened for unsupported nodes using the keyboard shortcut.#6206
Bug FixUser is unable to create a subscription if the host/IP address for connection is 127.0.0.1.#6253
Bug FixEnsure 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 FixUser is not able to change the connection in the Query tool when any SQL file is opened.#6272
Bug FixEnsure that the strings in the LDAP auth module are translatable.#6274
Bug FixSchema diff shows the wrong SQL when comparing triggers with different when clauses.#6281
Bug FixEnsure that the template database should be visible while creating the database.#6286
Bug FixString index out of range error where the dependent tab is in focus and selecting any publication or table.#6292
Bug FixProcedure creation failed when providing the Volatility option.#6293
Bug FixDependent tab threw an error when selecting any Login/Group role.#6294
Bug FixWhile selecting the row which was deleted just before the selection operation.#6306
Bug FixIncorrect values were visible in the Dependents tab for publication.#6307
Bug FixCopy/paste rows in view data paste the wrong value for Boolean type.#6312
Bug FixEnsure that the primary key should be visible properly in the Table dialog.#6316
Bug FixEnsure that toggle buttons are accessible by most screen readers.#6317
Bug FixEnsure that the grantor name should be visible properly for the Security tab in the Table dialog.#6323
Bug FixEnsure 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 FixEnsure that while comparing domains check function dependencies should be considered in schema diff.#6327
Bug FixWrong SQL is showing for the child partition tables.#6329
Bug FixSizing issue of help dialog for Query tool when open in the new browser tab.#6333
Bug FixCSV download quotes the numeric columns.#6341
Bug FixCannot unpack non-iterable response object error when selecting any partition.#6344
Bug FixEnsure that we should not allow opening external files that are dragged into it.#6355
Bug FixUsers are unable to see data of the partitions using the View/Edit data option.#6375
Bug FixA 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 FixSchema diff does not create DROP DEFAULT statements for columns.#6377
Bug FixForeign data wrapper properties are not visible if the host option contains two host addresses.#6379
Bug FixEnsure that Backup and Restore should work on shared servers.#6385
Bug FixThe filter 'Include/Exclude By Selection' is not working for null values.#6392
Bug FixEnsure that the user should not be able to add duplicate panels.#6399
Bug FixCurrent debug line is not visible in the 'Dark' theme.#6409
Bug FixDuplicate columns are visible in the browser tree, which is owned by two sequences.#6413
Bug FixHelp message was not displaying correctly on the Login/Group role.#6414
Bug FixQuery editor is not being closed if the user clicks on the 'Don't Save' button.#6417
Bug FixFile dialog shows incorrect files for the selected file types.#6443
Bug FixDuplicate SQL issue for tables with more than one partition.#6478