Softpedia >Windows >Internet >Servers >Database Utils >pgAdmin 4 >  Changelog

pgAdmin 4 Changelog

What's new in pgAdmin 4 8.6

May 2, 2024
  • New features:
  • Issue #6728 - Added the new columns “last_seq_scan” and “last_idx_scan” from the pg_stat_all_tables and pg_stat_all_indexes tables respectively to the Statistics tab.
  • Issue #7163 - Added support for excluding multiple tables while taking Backup.
  • Housekeeping:
  • Issue #7213 - Update UI library MUI from v4 to v5, more details here
  • Issue #7362 - Upgraded Flask, Flask-Security-Too, Werkzeug, and other dependencies, ensuring compatibility with Python 3.7.
  • Bug fixes:
  • Issue #2410 - Fixed all input boxes in pgAdmin to show browser auto-fill only where it is relevant.
  • Issue #7173 - Install dbus-python, an in-direct dependency of the Keyring package as a system package for Debian platforms.
  • Issue #7275 - Fixed an issue where debugger was not scrolling automatically on stepping.
  • Issue #7282 - Fixed an XSS vulnerability in the /settings/store endpoint (CVE-2024-4216).
  • Issue #7294 - Fixed an issue where double dollar quoted code is treated as string in syntax highlighter.
  • Issue #7317 - Fixed an issue where pressing backspace should remove the spaces and not the entire tab width, on enabling ‘Use spaces?’ in the preferences.
  • Issue #7334 - Fixed an issue where incorrect select/exec scripts were generated for functions/procedures.
  • Issue #7372 - Fixed an issue where connection to the database is not automatically re-established after connectivity drop.
  • Issue #7384 - Fixed an issue when closing the view data second tab; it raises the error that the ‘ViewCommand’ object has no attribute ‘auto_commit’.
  • Issue #7390 - Fixed violates check constraint issue when creating a pgAgent schedule.
  • Issue #7425 - Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215).

New in pgAdmin 4 8.5 (Apr 4, 2024)

  • New features:
  • Issue #5611 - Added support for provider, deterministic, version and RULES parameter while creating collation.
  • Issue #7098 - Added support for EDB Job Scheduler.
  • Issue #7216 - Added support for viewing Log Based Clusters.
  • Issue #7221 - Added support for UNIX socket in entrypoint.sh for Docker implementation.
  • Bug fixes:
  • Issue #4413 - Fixed an issue in Schema Diff where Columns with sequences get altered unnecessarily.
  • Issue #7111 - Fixed an issue where user was unable to share a newly registered server.
  • Issue #7116 - Bug fixes and improvements in pgAdmin CLI.
  • Issue #7139 - Fixed an issue where the ‘Save Password’ option for SSH tunneling password was consistently disabled.
  • Issue #7165 - Fixed schema diff wrong query generation for table, foreign table and sequence.
  • Issue #7210 - Fixed an issue where table properties were not updating from properties dialog.
  • Issue #7218 - Fixed an issue where maximize icon is missing from query tool panel.
  • Issue #7229 - Fix an issue in table dialog where changing column name was not syncing table constraints appropriately.
  • Issue #7248 - Fixed rollback and commit button activation on execute button click.
  • Issue #7255 - Fixed an issue where taking backup of a shared server was using server owner’s user name.
  • Issue #7262 - Fix an issue in editor where replace option in query tool edit menu is not working on non-Mac OS.
  • Issue #7268 - Fix an issue in editor where Format SQL shortcut and multiline selection are not working.
  • Issue #7269 - Fix an issue in editor where “Use Spaces?” Preference of Editor is not working.
  • Issue #7271 - Fixed an issue where Triggers, Rules, Indexes were absent from the Schema Diff when comparing views.
  • Issue #7277 - Fix an issue in query tool where toggle case of selected text loses selection.
  • Issue #7299 - Fix query tool autocomplete results when cursor is in between the SQL query.
  • Issue #7305 - Fix an issue in query tool where custom keyboard shortcuts are not working for some.
  • Issue #7304 - Fixed the issue where the update-user CLI command doesn’t change the password.
  • Issue #7308 - Fixed issue related to email authentication of Two-factor authentication.
  • Issue #7326 - Fixed a remote code execution issue in the validate binary path (CVE-2024-3116).

New in pgAdmin 4 8.4 (Mar 7, 2024)

  • New features:
  • Issue #6058 - Allow preferences customization using a configuration file.
  • Issue #7138 - Add support for JSON log format.
  • Issue #7204 - Add –yes option for skipping the confirmation prompt while deleting the user via CLI for scripting purpose.
  • Housekeeping:
  • Issue #7097 - Upgrade CodeMirror from version 5 to 6.
  • Issue #7148 - Added documentation for Dashboard’s System Statistics tab.
  • Issue #7187 - Separate the application name, branding & version information from the configuration file.
  • Issue #7234 - Upgrade python packages cryptography to 42.0.x and Flask-Security-Too to 5.3.x.
  • Bug fixes:
  • Issue #6792 - Fix multiple issues where PasswordExecCommand was not working in server mode and PasswordExecCommand was not loaded when importing servers.
  • Issue #6808 - Fix the tabbed panel backward/forward shortcut for tabs.
  • Issue #7027 - Fixed an issue where dependencies and dependents were not showing if a composite type is used as an attribute in another composite type.
  • Issue #7164 - Fix an issue where constraint check control is enabled in the edit table dialog.
  • Issue #7165 - Fix an issue where the scripts created by generate script of Schema diff for Table with sequence was not working earlier.
  • Issue #7193 - Ensure that the OAuth2 session is logged out when users log out from pgAdmin.
  • Issue #7217 - Remove role related checks on the UI dashboard when terminating session/query and let PostgreSQL take care of it.
  • Issue #7225 - Fix an issue where type column in dependents/dependencies tab is not showing correct label.
  • Issue #7258 - Unsafe Deserialization and Remote Code Execution by an Authenticated user in pgAdmin 4 (CVE-2024-2044).

New in pgAdmin 4 8.3 (Feb 9, 2024)

  • New features:
  • Issue #4419 - Allow drag-n-drop columns collection tree node as comma separated columns.
  • Issue #6380 - Added support to rename columns in Views.
  • Issue #6392 - Added BYPASSRLS|NOBYPASSRLS option while creating a Role.
  • Issue #6450 - Added support for column storage syntax while creating table.
  • Issue #6557 - Use COOKIE_DEFAULT_PATH or SCRIPT_NAME in session cookie path.
  • Issue #6792 - Added configurable parameter to enable support for PasswordExecCommand in server mode.
  • Bug fixes:
  • Issue #5083 - Fixed an issue where format sql was messing up operator. Included many other feature changes, more details here
  • Issue #6785 - Fixed an issue where formatting inserts empty lines in specific case.
  • Issue #7053 - Add support for selecting a schema in the backup database dialog with no tables, mviews, views or foreign tables.
  • Issue #7055 - Fixed a UI border issue on the dependencies tab for columns with icon.
  • Issue #7073 - Fixed an issue where multiple errors were showing if user does not have connect privileges.
  • Issue #7085 - Fixed an issue where group membership information was displayed incorrectly.
  • Issue #7113 - Ensure that the correct SQL is generated when changing the column data type to “char”.
  • Issue #7153 - Fixed an issue pgAdmin fails to launch due to inconsistent PATH variable name on windows.
  • Issue #7166 - Fix a backend server error when creating a named restore point.
  • Issue #7175 - Fix wrong default for FORCE_LOWER in the FLASK_GRAVATAR module.

New in pgAdmin 4 8.2 (Jan 11, 2024)

  • New features:
  • Issue #2483 - Administer pgAdmin Users and Preferences Using the Command Line Interface (CLI).
  • Issue #5908 - Allow users to convert View/Edit table into a Query tool to enable editing the SQL generated.
  • Issue #6085 - Added copy server support, allowing the duplication of existing servers with the option to make certain modifications.
  • Issue #7016 - Added keep-alive support for SSH sessions when connecting to a PostgreSQL server via an SSH tunnel.
  • Housekeeping:
  • Issue #6926 - Ensure that eventlet’s subprocess should be used following the resolution of an issue with Python 3.12 by eventlet.
  • Bug fixes:
  • Issue #6193 - Fixed an issue where query tool title did not change after “Save As” until any new change is made.
  • Issue #6781 - Fixed an issue where export servers was not adding extension if not specified.
  • Issue #6815 - Fixed an issue where pgAdmin imports servers to the wrong accounts for the external authentication.
  • Issue #7002 - Fixed an issue where an error occurred in the SQL tab when using an extended index(pgroonga).
  • Issue #7041 - Fixed an issue where changes done to a node using edit dialog are not reflecting on the properties tab if the properties tab is active.
  • Issue #7059 - Fixed an issue where DB Restrictions were not visible on the server dialog.
  • Issue #7061 - Ensure that the ‘Dbo’ schema is displayed as a regular schema rather than a system catalog schema.
  • Issue #7062 - Introduce LDAP configuration parameter LDAP_IGNORE_MALFORMED_SCHEMA to ignore fetching schema from the LDAP server.
  • Issue #7064 - Fixed an error-‘amname’ when generating ERD for database containing partition tables.
  • Issue #7066 - Fixed an issue where object explorer last tree state was not saving.
  • Issue #7070 - Fixed an issue where pgAgent job schedule dialog is not opening for edit.
  • Issue #7078 - Fixed an issue where user is not able to cancel or terminate active queries from dashboard.
  • Issue #7082 - Fixed browser autocomplete related issues on pgAdmin authentication related pages.
  • Issue #7091 - Fixed an issue where auto commit/rollback setting not persisting across query tool connection change.
  • Issue #7104 - Fixed an issue where Schema Diff not generating difference for missing columns.

New in pgAdmin 4 8.1 (Dec 14, 2023)

  • New features:
  • Issue #4580 - Add support for generating ERD for a schema.
  • Issue #6854 - Add support for creating a function with custom return type.
  • Housekeeping:
  • Issue #6991 - Fixed several accessibility-related issues for enhanced usability.
  • Bug fixes:
  • Issue #5471 - Ensure focus is not changed to ssh tunnel password input when user explicitly focus on server password input.
  • Issue #6095 - Provide a way to bypass the SSL cert verification for OAuth2 provider.
  • Issue #6488 - Fixed an issue where database name was missing in an error message if name contains any special characters.
  • Issue #6717 - Ensure that indexes created by constraints are visible in the object explorer when “Show system objects” is enabled.
  • Issue #6803 - Fixed an issue where reading process logs throws an error when DATA_DIR is moved to a networked drive.
  • Issue #6814 - Remove the ‘Close Window’ submenu specifically for OSX to prevent unintended closure of the entire application.
  • Issue #6842 - Rename all references of ‘Execute query’ to ‘Execute script’ to be more relevant.
  • Issue #6887 - Fixed an issue where syntax error was not highlighting in query tool.
  • Issue #6921 - Fixed an issue where on entering full screen, the option label is not changed to ‘Exit Full Screen’ in desktop mode.
  • Issue #6950 - Ensure that the Authentication Source in the drop-down of the UserManagement dialog aligns with the entries specified for AUTHENTICATION_SOURCES in the configuration file.
  • Issue #6958 - Reverse engineer serial columns when generating ERD for database/table.
  • Issue #6964 - Fixed an issue where the Schema was not visible in the dropdown for table properties or when creating a new table.
  • Issue #6968 - Fixed an issue where option key was not registering in PSQL tool.
  • Issue #6984 - Fixed an issue where the Vacuum option INDEX_CLEANUP have an incorrect value (‘AUTO’) for database versions < 14.
  • Issue #6989 - Fixed an issue where the pgAdmin page went blank when clicking the delete button in the User Management dialog.
  • Issue #7000 - Ensure that correct timezone is set for Docker deployments.
  • Issue #7011 - Fixed an issue where all rows and filter rows buttons of object explorer toolbar were disabled for views and other supported nodes.
  • Issue #7017 - Fixed an issue where schema diff tool is not loading preferences on start.

New in pgAdmin 4 8.0 (Nov 23, 2023)

  • New features:
  • Issue #2821 - Have close buttons on individual panel tabs instead of common.
  • Issue #4733 - Allow closing all the tabs, including SQL and Properties.
  • Issue #5394 - Changes in the context menu on panel tabs - Add close, close all and close others menu items.
  • Housekeeping:
  • Issue #6441 - Update app bundle built to use notarytool instead of altool.
  • Issue #6479 - Replace the current layout library wcDocker with ReactJS based rc-dock.
  • Issue #6850 - Upgrade Flask, Werkzeug and other modules depends on the latest version of Flask.
  • Bug fixes:
  • Issue #2986 - Fix an issue where the scroll position of panels was not remembered on Firefox.
  • Issue #5770 - Add DROP SQL for foreign keys in SQL generated by ERD when using WITH DROP option.
  • Issue #5807 - Fixed an issue where psql was not taking the role used to connect in server properties.
  • Issue #6017 - Fixed an issue where Geometry Viewer renders geometry incorrectly after trying to view 3D or non-4326 SRID geometry.
  • Issue #6459 - Fix the sorting of size on the statistics panel.
  • Issue #6487 - Fixed restoration of query tool database connection after dropping and re-creating the database with the same name.
  • Issue #6602 - Fix an issue where the default server-group is being deleted if the load-server json file contains no servers.
  • Issue #6720 - Fix an issue of the incorrect format (no indent) of SQL stored functions/procedures.
  • Issue #6769 - Server config information in the about dialog should be only visible to admin users.
  • Issue #6784 - Fixed an issue where Schema Diff does not work when the user language is set to any language other than English in Preferences.
  • Issue #6817 - Fixed the query generated when creating subscription where copy_data parameter was missing.
  • Issue #6820 - Ensure backup/restore/maintenance works with invalid pgpass file parameter.
  • Issue #6835 - Fix an issue where OAUTH_ADDITIONAL_CLAIMS does not recognise AzureAD with > 150 groups.
  • Issue #6840 - Fixed circular import error occurring while deploying cloud PostgreSQL instance from pgAdmin.
  • Issue #6874 - Fix an issue where the browser window stuck on spinning with an Oauth user without email.
  • Issue #6875 - Fix an issue where import/export data is not working for shared servers.
  • Issue #6877 - Remove the max length of 255 from password exec command in server configuration dialog.
  • Issue #6884 - Remove gettext from empty strings in the title of the storage graph.
  • Issue #6902 - Fixed an issue where the change server password is not working in desktop mode.
  • Issue #6904 - Fix a crash issue occurring when debugging a function with arguments when using pgAdmin with external config database.
  • Issue #6920 - Fix an issue in ERD tool where SQL generated is missing columns for the table.
  • Issue #6934 - Clear the password field in the config database on clear saved server password.
  • Issue #6962 - Fixed an issue where the data type of the array type was not visible for the column in the Foreign Table dialog.

New in pgAdmin 4 7.8 (Oct 19, 2023)

  • New features:
  • Issue #640 - Add support for foreign table’s new functionality for PG 11 and above.
  • Issue #6229 - Allow setting custom username for shared servers, with default as username of server being shared.
  • Issue #6373 - Add ‘GENERATED ALWAYS AS..’ option while creating column constraints for Foreign Table.
  • Issue #6797 - GUI representation of the system’s activity using the ‘system_stats’ extension.
  • Issue #6802 - Added ‘load_balance_hosts’ connection string parameter for PG 16 and above.
  • Housekeeping:
  • Issue #6782 - Use PG16 as the default PostgreSQL version.
  • Bug fixes:
  • Issue #4995 - Fixed an issue in ERD tool where the downloaded images have a few links cut.
  • Issue #5749 - Fixed an issue where user was not able to assign new/old columns as primary key once column with primary key is deleted.
  • Issue #6285 - Add support for setting prepare threshold in server connection.
  • Issue #6482 - Fixed an issue where the wrong message “Current database has been moved or renamed” is displayed when debugging any function.
  • Issue #6538 - Fixed an issue where Processes tab displays wrong server name in some scenario.
  • Issue #6579 - Fix an issue where global/native keyboard shortcuts are not working when any cell of data output grid has focus.
  • Issue #6666 - Fixed query history slowness issue by storing query only for those having certain threshold max length.
  • Issue #6674 - Fix an issue where foreign table column name becomes “none” if the user changes any column data type.
  • Issue #6718 - Pin the cryptography version to fix PyO3 modules initialisation error.
  • Issue #6790 - Ensure that the backup works properly for PG 16 on the latest docker image.
  • Issue #6799 - Fixed an issue where the user is unable to select objects on the backup dialog due to tree flickering.
  • Issue #6836 - Fixed an issue where non-super PostgreSQL users are not able to terminate their own connections from dashboard.
  • Issue #6851 - Fix an issue where scale in columns is not allowed to have value as 0 or below.
  • Issue #6858 - Fix an issue in graphical explain plan where query tool crashes when the plan has parallel workers details and sort node is clicked for details.
  • Issue #6865 - Fix an issue where user login is not working if username/email contains single quote in server mode.

New in pgAdmin 4 7.7 (Sep 21, 2023)

  • New features:
  • Issue #2078 - Show object breadcrumbs path along with its comment on object hover.
  • Issue #3275 - Allow on demand record count setting to be changed per user using preferences.
  • Issue #3316 - Added support to show statistics for materialized views.
  • Issue #3318 - Added support to create an unnamed index.
  • Housekeeping:
  • Bug fixes:
  • Issue #5044 - Fixed an issue where query tool hangs for some time when multiple columns are selected to open geometry viewer.
  • Issue #5777 - Fixed an issue where the browser tree state is not remembered when reopening pgAdmin.
  • Issue #5820 - Fixed an issue where collation was set to none if we remove it while creating partitioned table.
  • Issue #5922 - Ensure that when pasting a row in query tool grid, default value is used for autogenerated/serial columns.
  • Issue #6059 - Show proper message if the debugger is stopped by the user.
  • Issue #6075 - Ensure that the save button is enabled when registering a new server fails due to an API error.
  • Issue #6077 - The search object, query tool, and psql tool menu should not be displayed for pgAgent.
  • Issue #6120 - Fixed error occurring while logging out from pgAdmin keeping a query tool opened.
  • Issue #6128 - Fix a SQL error occurring on roles dependents SQL.
  • Issue #6130 - Ensure to quote the primary key value if needed while deleting rows from the table.
  • Issue #6137 - Fixed error occurring while dumping the servers from CLI.
  • Issue #6138 - Throw an appropriate error when a table for which View/Edit data is open, is deleted, and query is executed.
  • Issue #6151 - Ensure that internal users are able to login when auth sources are [ldap, internal].
  • Issue #6158 - Fixed an issue with the properties tab not getting updated if the user updates the selected node.
  • Issue #6159 - Ensure that the ERD tool should work with the external database after moving to psycopg3.
  • Issue #6180 - Fixed an issue where PSQL is not working if the PGUSER env variable is set and service file is used for server connection details.
  • Issue #6183 - Mac crash when you press Command-Shift-C.
  • Issue #6189 - Fix an issue in View SQL when column level privileges are set with multiple roles.
  • Issue #6191 - Fixed an issue where Reset Password is not working after upgrading to latest flask-security-too.
  • Issue #6234 - Usernames/roles with special character are not double quoted when assigning privileges.

New in pgAdmin 4 7.6 (Aug 24, 2023)

  • New features:
  • Issue #2595 - Added Expression to CREATE INDEX.
  • Issue #3942 - Added cascade option while creating an extension.
  • Issue #5759 - Added ‘Ignore Grants’ option in the schema diff tool.
  • Issue #6004 - Added ‘Ignore Tablespace’ option in the schema diff tool.
  • Issue #6375 - Added support for ALTER INDEX column statistics.
  • Issue #6376 - Added unlogged option while creating a sequence.
  • Issue #6377 - Added all like options while creating a table.
  • Issue #6381 - Added support for SYSTEM, CONCURRENTLY and TABLESPACE options in REINDEX.
  • Issue #6382 - Added WAL option to EXPLAIN ANALYZE command.
  • Issue #6397 - Added new/missing options to the VACUUM command.
  • Issue #6415 - Added SKIP_LOCKED and BUFFER_USAGE_LIMIT option to Analyze command.
  • Issue #6448 - Add support for TRUNCATE trigger in foreign table.
  • Issue #6595 - Ensure that Schema Diff comparison results should be displayed in the sorted order.
  • Housekeeping:
  • Issue #3702 - Generate software bill of materials as part of the package builds.
  • Issue #6588 - Added support for PostgreSQL and EPAS 16 to ensure it works without any errors.
  • Bug fixes:
  • Issue #5454 - Fix incorrect redirection URL after authentication by removing fixed value set to SCRIPT_NAME environment variable in pgAdmin4.wsgi file.
  • Issue #6208 - Allow changing the POOL_SIZE and MAX_OVERFLOW config values of the pgAdmin config DB connection pool.
  • Issue #6252 - Fix an issue where query tool on shared server is throwing error if the pgAdmin config DB is external.
  • Issue #6420 - Fix the query tool issue where raise Notice from func/proc or code blocks are no longer displayed live.
  • Issue #6500 - Fix the issue where query tool window turns blank if the user tries to generate a graph on the result.
  • Issue #6624 - Fix an issue where changing MFA_SUPPORTED_METHODS breaks the MFA validation.
  • Issue #6630 - Fix an issue where pgAdmin 7.5 fails to render table SQL with extension loaded index method.
  • Issue #6639 - Fix an issue where cycle syntax was not added in SQL when creating new sequence from UI.
  • Issue #6651 - Fix an issue where the SET directive is excluded from the function header in the schema diff tool.
  • Issue #6660 - Fix a query tool error ‘pgAdminThread’ object has no attribute ‘native_id’.
  • Issue #6664 - Ensure keyboard shortcut for query execution is disabled when query execution is in progress.

New in pgAdmin 4 7.5 (Jul 27, 2023)

  • New features:
  • Added support to detach partitions using concurrently and finalize.
  • Added all supported index storage parameters while creating an index.
  • Added new/missing parameters to pg_dumpall (Backup Server).
  • Added new/missing parameters to pg_dump (Backup Objects).
  • Added new/missing parameters to pg_restore.
  • Housekeeping:
  • Remove Bootstrap and jQuery from authentication pages and rewrite them in ReactJS.
  • Enable cluster deployment with gp3 volume for AWS & BigAnimal cloud providers.
  • Clarify the LICENSE file to indicate that it is the PostgreSQL Licence.
  • Remove unsupported PostgreSQL versions from the container.
  • Bug fixes:
  • Fix an issue where queries can’t complete execution.
  • Fixed an issue where Import Export not working when using pgpassfile.
  • Fix an issue where queries longer than 1 minute get stuck - Container 7.1
  • Fix an issue where queries get stuck with auto-completion enabled.
  • Fixed Query Tool/ PSQL tool tab title not getting updated on database rename.
  • Ensure user gets proper error if incorrect credentials are entered while authenticating AWS.
  • Fix an issue where the edit server fails in desktop mode if the server password is not stored.
  • Ensure that Backup, Restore, and Maintenance should work properly when pgpass file is used.
  • Fix the query tool auto-complete issue on the server reconnection.
  • Fix the query tool restore connection issue.
  • Fix the reconnecton issue if the PostgreSQL server is restarted from the backend.
  • Fix the connection and stability issues since v7, possibly related to background schema changes.
  • Fixed an issue where the query tool is unable to execute a query on Postgres 10 and below versions.
  • Fix the lost connection error in v7.4.
  • Fixed an issue where pgAdmin failed to setup role with hyphens in name.
  • Fixed an issue where filters are not working and query history shows empty queries.
  • Fix an issue where adding a sub-folder inside a folder is not working as expected in File Manager.
  • Fix an error ‘list’ object has no attribute ‘strip’ while attempting to populate auto-complete manually the first time.
  • Fixed an issue where ERD Tool can’t load the saved pgerd file from Shared Storage.
  • Fix an issue where inserting more than 10 rows does not work correctly in View Data; only parts end up in the table.

New in pgAdmin 4 7.4 (Jun 29, 2023)

  • New features:
  • Added support to drop databases using the ‘WITH (FORCE)’ option.
  • Add “[ NULLS [ NOT ] DISTINCT ]” option while creating an Index.
  • Added ‘OR REPLACE’ clause while creating trigger.
  • Added security_invoker option while creating a view.
  • Housekeeping:
  • Bug fixes:
  • Fix an issue where object explorer tree crashes occasionally.
  • Ensure that query tool shortcuts are working properly.
  • Add Password exec command and Expiration time to server export JSON and also allow them to import.
  • When opening pgAdmin the layout should be auto reset if it is corrupted. Reset layout menu should work if layout is corrupted while using pgAdmin.
  • Fix an issue where loading more rows indicator will not disappear if connection is lost.
  • Fix an encoding error when connecting through Pgbouncer.
  • Fix an issue where explain plan details is showing HTML escaped characters.
  • Fixed an issue where queries with temporary tables in the same transaction is not working.
  • Fixed an issue where preview images for themes were not loading.
  • Fix raise notice from func/proc or code blocks are no longer displayed live.
  • Fix an issue where PSQL is not working if the database name have quotes or double quotes.
  • Fix an issue where all the menus are enabled when pgAdmin is opened and no object is selected in the object explorer.

New in pgAdmin 4 7.3 (Jun 6, 2023)

  • Bug fixes:
  • Fix an issue where editing a database object de-selects it on the browser tree.
  • Ensure that SSH Tunnel should work properly after upgrading to 7.2 from 7.1
  • Fixed an issue where pgadmin is unable to take the defined role.
  • Fixed an issue where Foreign Key with 3 or more columns are shown in the wrong order in SQL and Properties.
  • Ensure that the master password dialog should not be visible if the parameter MASTER_PASSWORD_REQUIRED is set to False.

New in pgAdmin 4 7.1 (May 4, 2023)

  • Supported Database Servers:
  • PostgreSQL: 11, 12, 13, 14 and 15
  • EDB Advanced Server: 11, 12, 13, 14 and 15
  • Bundled PostgreSQL Utilities:
  • psql, pg_dump, pg_dumpall, pg_restore: 15.2
  • New features:
  • Issue #2078 - Show object breadcrumbs path along with its comment on object hover.
  • Issue #3275 - Allow on demand record count setting to be changed per user using preferences.
  • Issue #3316 - Added support to show statistics for materialized views.
  • Issue #3318 - Added support to create an unnamed index.
  • Housekeeping:
  • Bug fixes:
  • Issue #5044 - Fixed an issue where query tool hangs for some time when multiple columns are selected to open geometry viewer.
  • Issue #5777 - Fixed an issue where the browser tree state is not remembered when reopening pgAdmin.
  • Issue #5820 - Fixed an issue where collation was set to none if we remove it while creating partitioned table.
  • Issue #5922 - Ensure that when pasting a row in query tool grid, default value is used for autogenerated/serial columns.
  • Issue #6059 - Show proper message if the debugger is stopped by the user.
  • Issue #6075 - Ensure that the save button is enabled when registering a new server fails due to an API error.
  • Issue #6077 - The search object, query tool, and psql tool menu should not be displayed for pgAgent.
  • Issue #6120 - Fixed error occurring while logging out from pgAdmin keeping a query tool opened.
  • Issue #6128 - Fix a SQL error occurring on roles dependents SQL.
  • Issue #6130 - Ensure to quote the primary key value if needed while deleting rows from the table.
  • Issue #6137 - Fixed error occurring while dumping the servers from CLI.
  • Issue #6138 - Throw an appropriate error when a table for which View/Edit data is open, is deleted, and query is executed.
  • Issue #6151 - Ensure that internal users are able to login when auth sources are [ldap, internal].
  • Issue #6158 - Fixed an issue with the properties tab not getting updated if the user updates the selected node.
  • Issue #6159 - Ensure that the ERD tool should work with the external database after moving to psycopg3.
  • Issue #6180 - Fixed an issue where PSQL is not working if the PGUSER env variable is set and service file is used for server connection details.
  • Issue #6183 - Mac crash when you press Command-Shift-C.
  • Issue #6189 - Fix an issue in View SQL when column level privileges are set with multiple roles.
  • Issue #6191 - Fixed an issue where Reset Password is not working after upgrading to latest flask-security-too.
  • Issue #6234 - Usernames/roles with special character are not double quoted when assigning privileges.

New in pgAdmin 4 6.21 (Mar 9, 2023)

  • This release contains a number of bug fixes and new features since the release of pgAdmin 4 v6.20.
  • New features:
  • Issue #5832 - Allow changing cardinality notation in ERD to use Chen notation.
  • Issue #5842 - Add additional logging for successful logins and user creation.
  • Housekeeping:
  • Bug fixes:
  • Issue #5269 - Ensure that the schema diff tool should pick up the change in the column grants.
  • Issue #5685 - Ensure that Grant column permission to a view is visible in the SQL tab.
  • Issue #5747 - Ensure that content on the DDL comparison panel should get refreshed on selecting the object using the up and down arrow keys.
  • Issue #5756 - Fix for query tool prompting for unsaved changes even if no changes have been made.
  • Issue #5758 - Fixed an issue where lock layout menu was not in sync with preferences.
  • Issue #5760 - Fixed an issue where query was not pasted to editor after trojan source warning.
  • Issue #5764 - Fix an issue where the maintenance dialog for Materialized View gives an error.
  • Issue #5773 - Fixed an issue where Clear Saved Password should be disabled if the password is already cleared.
  • Issue #5790 - Fixed an issue where the user can’t create trigger AFTER UPDATE OF.
  • Issue #5803 - Fix an issue where query tool is stripping spaces in grid cell.
  • Issue #5810 - Fix an issue where sequence owner is remove on sequence edit.
  • Issue #5822 - Do not allow to save invalid JSON in query tool JSON editor.
  • Issue #5847 - Fixed an issue where pgAdmin failed to connect when the Postgres password included special characters.
  • Issue #5870 - Ensure that the database migration does not fail with a NoSuchTableError exception.
  • Issue #5872 - Handle MERGE operation in query tool explain introduced in PostgreSQL 15.
  • Issue #5889 - Fixed an issue where the database server is not connected using a service file.
  • Issue #5909 - Fixed an issue where the file name in the query tool tab was not changing if another file is opened.

New in pgAdmin 4 6.17 (Dec 2, 2022)

  • New features:
  • Housekeeping:
  • Issue #5147 - Update the BigAnimal API version to V2.
  • Issue #5493 - Remove all traces of Backbone and Underscore.
  • Bug fixes:
  • Issue #5488 - Fixed an issue where the wrong schema is displayed for a foreign key in the schema diff tool.
  • Issue #5495 - Ensure that the query history date format in Desktop mode matches the format of the locale of the pgadmin server.
  • Issue #5505 - Fixed an issue where the CSV file would not download if the CSV quote character length exceeded 1.
  • Issue #5513 - Ensure that DATA_DIR dependent folders/files are automatically created inside the specified DATA_DIR if they are not specified separately in the configuration file.
  • Issue #5539 - Improved error message to make it easier for users to understand.
  • Issue #5548 - Fixed an issue where editor position was wrong when editing data from result grid.
  • Issue #5575 - Ensure the query tool is launched successfully for the servers registered with the PostgreSQL service.
  • Issue #5593 - Ensure that only authorized and authenticated users can validate binary paths (CVE-2022-4223).

New in pgAdmin 4 6.16 (Nov 19, 2022)

  • Supported Database Servers:
  • PostgreSQL: 10, 11, 12, 13, 14 and 15
  • EDB Advanced Server: 10, 11, 12, 13, 14 and 15
  • New features:
  • Issue #1832 - Added support for storing configurations of pgAdmin in an external database.
  • Issue #4756 - Added the ability to generate ERDs for tables.
  • Issue #5468 - Add the possibility to configure the Oauth2 claim which is used for the pgAdmin username.
  • Housekeeping:
  • Bug fixes:
  • Issue #2174 - Ensure that the browser tree should auto scroll to the selected node when expanding the server node.
  • Issue #4841 - Use SocketIO instead of REST for schema diff compare.
  • Issue #5066 - Ensure that users can use custom characters as CSV field separators/CSV quotes when downloading query results.
  • Issue #5058 - Ensure that the save button should be disabled by default on the Sort/Filter dialog in the query tool.
  • Issue #5098 - Fix an issue where the save button is enabled when the table properties dialog is opened.
  • Issue #5122 - Ensure that the spinner should be visible on the browser tree on node refresh.
  • Issue #5149 - Ensure the Generate ERD option is hidden if the connection to the database is not allowed.
  • Issue #5206 - Reposition the select dropdown when the browser is resized.
  • Issue #5281 - Ensure that autocomplete works properly with objects starting with double quotes.
  • Issue #5344 - Ensure that pgAdmin routes should have the SCRIPT_NAME prefix.
  • Issue #5424 - Ensure that the appropriate permissions are set on the key file before trying an SSL connection with the server in server mode.
  • Issue #5429 - Fixed an issue where parameters for roles were not visible.
  • Issue #5452 - The container deployment document should include the server.json file format.
  • Issue #5455 - Fixed an issue where the dependents tab wasn’t working for PG 15.
  • Issue #5458 - Ensure that the browser path column in the search object shows the complete path.
  • Issue #5463 - Fixed an issue where the result grid was not working properly while trying to edit data by hitting Enter key.
  • Issue #5465 - Fixed an issue where the screen was freezing while closing the wcDocker panel.
  • Issue #5473 - Fixed an issue where AutoComplete was not working correctly due to incorrect regex.
  • Issue #5475 - Fixed an issue where the ‘Confirm on close or refresh’ setting was ignored when closing the query/ERD tool opened in the new tab.
  • Issue #5507 - Fixed an issue where pgadmin does not respect reverse proxy any more.
  • Issue #5521 - Fixed SocketIO calls when pgAdmin 4 server is running from a sub directory.
  • Issue #5522 - Ensure that the load file paths are children of the storage directory.
  • Issue #5533 - Use the shared server username when opening query tool.
  • Issue #5535 - Fixed an issue where the ‘save_password’ column threw an error for the shared server when using an external database.
  • Issue #5537 - Ensure that the correct error message in ERD for permission denied should be shown.

New in pgAdmin 4 6.15 (Oct 20, 2022)

  • New features:
  • Added support for IAM token based authentication for AWS RDS or Azure DB.
  • Added support to specify the background fill color to the table nodes in the ERD tool.
  • Allow reordering table columns using drag and drop in ERD Tool.
  • Add option to generate SQL with DROP table DDL in ERD Tool.
  • Added high availability options to AWS deployment.
  • Expose the Gunicorn limit_request_line parameter in the container, with the default set to the maximum 8190.
  • Housekeeping:
  • Use SocketIO instead of REST for fetching database tables data in ERD.
  • Ensure that the tooltips are consistent throughout the entire application.
  • Remove Python’s ‘Six’ package completely.
  • Bug fixes:
  • Ensure consistent orderings for ACLS when comparing schemas in the schema diff.
  • Ensure that the result grid column should take width as pre preferences setting on first execution.
  • Fixed an exception occur while taking backup and SSL certificates/keys are not found in the specified path.
  • Fixed intermittent error shown while OAuth2 login.
  • Ensure that the path to the psqlrc file is correct when multiple users open the PSQL tool at the same time.
  • Ensure that the continue/start button should be disabled if the user stops the Debugger for the procedures.
  • Ensure that the query tool creates a new tab with the appropriate user when pressing Alt+Shift+Q.
  • Added the close button for all the notifications of the notistack.
  • Added the ability to display the selected text from the query tool in the find/replace box.
  • Ensure that the search filter should be cleared when a new row is added to the user management.
  • Ensure that the user management dialog should not allow the same email addresses with different letter casings when creating users.
  • Fixed XSS vulnerability issues.
  • Ensure that the scroll position should be preserved for the result set in the query tool on tab change.
  • Ensure that the default value for a column should be used if it is made empty.
  • Fixed an issue where user was unable to select privileges in Safari.
  • Fixed console warning shown while updating database node from browser tree.
  • Fixed an issue where the prompt is not visible when clicking on the ‘save results to file’ button on the large data.
  • Fixed error occurring while LDAP authentication for a user with multiple email attributes.
  • Fixed an issue where notifications disappeared quickly.
  • Ensure that the correct value should be returned if an exception occurs while decoding the password.
  • Fixed the issue while downloading the file from the file manager.
  • Ensure that the login form is hidden if the authentication source is OAuth2 or Kerberos.
  • Fixed an issue where the password recovery link was not working.Ensure that scroll bar on browser tree should be visible on windows resize.
  • Fixed the cross-site scripting vulnerability.
  • Fixed an issue where filtered rows were not working.

New in pgAdmin 4 6.14 (Sep 22, 2022)

  • New features:
  • Housekeeping:
  • Port schema diff to React.
  • Remove Backgrid and Backform.
  • Port the remaining components of the ERD Tool to React.
  • Updated keyboard shortcut documentation.
  • Remove Alertify from pgAdmin completely.
  • Port search object dialog to React.
  • Bug fixes:
  • Ensure that if big animal authentication is aborted, API calls should be stopped.
  • Fixed an issue where pgAdmin failed to start due to bin path migration.
  • Fixed an issue where backup does not work due to parameter ‘preexec_fn’ no longer being supported.
  • Ensure that the browser tree should be refreshed after changing the ownership.
  • Fixed the error message displayed when clicking the cloud server for which deployment is in progress.
  • Fixed an issue where the wrong SQL displayed in difference if the user create an RLS policy on the table without a column.
  • Ensure that the dump servers functionality works from setup.py.
  • Ensure that the Import/Export server menu option is visible.
  • Fixed API test case for change password in the server mode.
  • Fixed an issue with the non-visibility of columns added prior to import/export data.
  • Fixed an issue where textarea of the JSON Editor does not resize with dialog.
  • Fixed ModuleNotFoundError when running setup.py to load/dump servers.
  • Replace the language selection ‘Brazilian’ with ‘Portuguese (Brazilian).
  • Fixed an issue where server names with special characters are not displayed correctly in the process tab.
  • Fixed an issue where ERD throws an error if variable is added to the column.
  • Fixed an error while saving changes to the ERD table.
  • Fixes a redirect vulnerability when the user opens the pgAdmin URL.

New in pgAdmin 4 6.13 (Aug 25, 2022)

  • This release contains a number of bug fixes and new features since the release of pgAdmin 4 v6.12.
  • New features:
  • Issue #3709 - Added support to show all background processes in separate panel.
  • Issue #7387 - Added support to create triggers from existing trigger functions in EPAS.
  • Housekeeping:
  • Issue #7344 - Port Role Reassign dialog to React.
  • Issue #7345 - Port User Management dialog to React.
  • Issue #7404 - Port process watcher to React.
  • Issue #7462 - Remove the SQL files for the unsupported versions of the database server.
  • Issue #7567 - Port About dialog to React.
  • Issue #7568 - Port change user password and 2FA dialog to React.
  • Issue #7590 - Port change ownership dialog to React.
  • Issue #7595 - Update the container base image to Alpine 3.16 (with Python 3.10.5).
  • Issue #7602 - Fixed improper parsing of HTTP requests in Pallets Werkzeug v2.1.0 and below (CVE-2022-29361).
  • Bug fixes:
  • Issue #7452 - Ensure that an error is thrown if clipboard access is not provided and change the copy rows shortcut.
  • Issue #7468 - Fixed an issue where the History tab is getting blank and showing an error after some queries are executed.
  • Issue #7481 - Fixed an issue where OWNED BY was incorrectly set to NONE when adding user privileges on the sequence.
  • Issue #7497 - Fixed an issue with the error message being displayed at the right place for Azure deployments.
  • Issue #7521 - Fixed an issue where the Query Editor loses focus when saving a query (Alt+s).
  • Issue #7527 - Fixed API test cases for Postgres 14.4.
  • Issue #7540 - Ensure that rename panel should work on view/edit panels.
  • Issue #7563 - Fixed an issue where autocomplete is not working after clearing the query editor.
  • Issue #7573 - Ensure that autocomplete does not appear when navigating code using arrow keys.
  • Issue #7575 - Fixed an issue where Alt-Shift-Q didn’t work after creating a new query.
  • Issue #7579 - Fixed an issue where copy and pasting a row in the results grid doesn’t set the default for boolean.
  • Issue #7586 - Fixed an issue with rendering geometry when selecting a complete column.
  • Issue #7587 - Ensure that the children of information_schema and pg_catalog node should be displayed.
  • Issue #7591 - Fixed column “none” does not exist issue, while comparing schema objects.
  • Issue #7596 - Fixed an issue where schema diff did not pick up the change in RLS policy.
  • Issue #7608 - Fixed an issue where the cloud deployment wizard creates the cluster with the High Availability even if that option is not selected.
  • Issue #7611 - Ensure that schema diff maintains view ownership when view definitions are modified.
  • Issue #7614 - Fixed crypt key is missing issue when logout from the pgAdmin.
  • Issue #7616 - Ensure that the next button should be disabled if the password did not match for Azure deployment.
  • Issue #7617 - Fixed an issue where Azure cloud deployment failed.
  • Issue #7625 - Fixed Spanish translations typo.
  • Issue #7630 - Ensure that If the trigger function definition is changed, drop and recreate the trigger in the schema diff.
  • Issue #7632 - Fixed an issue where a user could not authenticate using Azure CLI on OSX.
  • Issue #7633 - Ensure that the autofocus is on the input control for the master password and server password dialogs.
  • Issue #7641 - Pin Flask-SocketIO <= v5.2.0. The latest version does not support Werkzeug in production environments.

New in pgAdmin 4 6.12 (Jul 28, 2022)

  • New features:
  • Issue #4488 - Added option to trigger autocomplete on key press in the query tool.
  • Issue #4607 - Allow users to delete files/folders from the storage manager.
  • Issue #7389 - Allow users to search within the file/storage manager.
  • Issue #7486 - Added support for visualizing the graphs using Stacked Line, Bar, and Stacked Bar charts in the query tool.
  • Issue #7487 - Added support for visualise the graph using a Pie chart in the query tool.
  • Housekeeping:
  • Issue #7313 - Port the file/storage manager to React.
  • Issue #7341 - Port change password dialog to React.
  • Issue #7342 - Port Master Password dialog to React.
  • Issue #7492 - Removing dynamic module loading and replacing it with static loading.
  • Issue #7546 - Port named restore point dialog to React.
  • Bug fixes:
  • Issue #7428 - Preserve the settings set by the user in the import/export data dialog.
  • Issue #7471 - Ensure that the splash screen can be moved.
  • Issue #7508 - Fixed an issue where comments on indexes are not displayed.
  • Issue #7512 - Ensure that notices should not disappear from the messages tab.
  • Issue #7517 - Enable the start debugging button once execution is completed.
  • Issue #7518 - Ensure that dashboard graph API is not called after the panel has been closed.
  • Issue #7519 - Ensure that geometry should be shown for all the selected cells.
  • Issue #7520 - Fixed the JSON editor issue of hiding the first record.
  • Issue #7522 - Added support for Azure PostgreSQL deployment in server mode.
  • Issue #7523 - Fixed typo error for Statistics on the table header.
  • Issue #7524 - Fixed an issue where new folders cannot be created in the save dialog.

New in pgAdmin 4 6.11 (Jun 30, 2022)

  • New features:
  • Issue #2647 - Added mouse over indication for breakpoint area in the Debugger.
  • Issue #2648 - Added search text option to the Debugger panel.
  • Issue #7178 - Added capability to deploy PostgreSQL servers on Microsoft Azure.
  • Issue #7332 - Added support for passing password using Docker Secret to Docker images.
  • Issue #7351 - Added the option ‘Show template databases?’ to display template databases regardless of the setting of ‘Show system objects?’.
  • Issue #7485 - Added support for visualise the graph using a Line chart in the query tool.
  • Bug fixes:
  • Issue #7423 - Fixed an issue where there is no setting to turn off notifications in the Query Tool.
  • Issue #7440 - Fixed an issue where passwords entered in the ‘Connect To Server’ dialog were truncated.
  • Issue #7441 - Ensure that the Query Editor should be focused when switching between query tool tabs.
  • Issue #7443 - Fixed and issue where ‘Use spaces’ not working in the query tool.
  • Issue #7453 - Fixed an issue where the Database restriction is not working.
  • Issue #7460 - Fixed an issue where pgAdmin stuck while creating a new index.
  • Issue #7461 - Fixed an issue where the connection wasn’t being closed when the user switched to a new connection and closed the query tool.
  • Issue #7468 - Skip the history records if the JSON info can’t be parsed instead of showing ‘No history’.
  • Issue #7502 - Fixed an issue where an error message is displayed when creating the new database.
  • Issue #7506 - Fixed permission denied error when deploying PostgreSQL in Azure using Docker.

New in pgAdmin 4 6.10 (Jun 2, 2022)

  • New features:
  • Issue #7364 - Added the ability to resize columns on dashboard tables.
  • Housekeeping:
  • Issue #7283 - PG 15 compatibility issues fixed.
  • Issue #7337 - Port connect server password dialog to React.
  • Bug fixes:
  • Issue #6962 - Fixed the browser tree overlapping nodes and expansion issue.
  • Issue #7002 - Added the ability to detect and warn users about bidirectional Unicode characters.
  • Issue #7347 - Ensure that when Authentication buttons are disabled their text is visible in the Dark and High contrast theme.
  • Issue #7368 - Ensure that unwanted APIs should not be getting called for BigAnimal.
  • Issue #7372 - Tell Docker to always pull the latest base images when building containers.
  • Issue #7373 - Fixed an issue with geometry window zoom mouse scroll not working.
  • Issue #7374 - Fixed an issue when switching between connections in the Query Tool dropdown, the background and foreground colors should be changed.
  • Issue #7376 - Fixed an issue where a popup for unsaved changes appears when clicking on the open file button for a blank query editor.
  • Issue #7380 - Added support for multi-cell selection in the query tool grid.
  • Issue #7383 - Fixed an issue where Preferences are not saved when the dialog is maximized.
  • Issue #7388 - Fixed an issue where an error message fills the entire window if the query is long.
  • Issue #7393 - Ensure that the editor position should not get changed once it is opened.
  • Issue #7394 - Fixed an issue where geometry is not visible when a single cell is selected.
  • Issue #7399 - Added missing toggle case keyboard shortcuts to the query tool.
  • Issue #7402 - Ensure that Dashboard graphs should be refreshed on changing the node from the browser tree.
  • Issue #7403 - Fixed an issue where comments on domain constraints were not visible when selecting a domain node.
  • Issue #7405 - Ensure that null values are accepted for the numeric columns in react-data-grid.
  • Issue #7408 - Fixed an issue when a table has a column with an array type with length or precision, the column type is not selected while editing the table.

New in pgAdmin 4 6.9 (May 12, 2022)

  • New features:
  • Issue #3253 - Added status bar to the Query Tool.
  • Issue #3989 - Ensure that row numbers should be visible in view when scrolling horizontally.
  • Issue #6830 - Relocate GIS Viewer Button to the Left Side of the Results Table.
  • Issue #7179 - Added capability to deploy PostgreSQL servers on EDB BigAnimal.
  • Issue #7282 - Added options ‘Ignore owner’ and ‘Ignore whitespace’ to the schema diff panel.
  • Issue #7325 - Added support for Azure AD OAUTH2 authentication.
  • Housekeeping:
  • Issue #6131 - Port query tool to React.
  • Issue #6746 - Improve the Kerberos Documentation.
  • Issue #7255 - Ensure the database and schema restriction controls are not shown as a drop-down.
  • Issue #7340 - Port data filter dialog to React.
  • Bug fixes:
  • Issue #6725 - Fixed an issue where the Query tool opens on minimum size if the user opens multiple query tool Window quickly.
  • Issue #6958 - Only set permissions on the storage directory upon creation.
  • Issue #7026 - Fixed an issue where the Browser panel is not completely viewable.
  • Issue #7168 - Improvement to the Geometry Viewer popup to change the size of the result tables when column names are quite long.
  • Issue #7187 - Fixed an issue where the downloaded ERD diagram was 0 bytes.
  • Issue #7188 - Fixed an issue where the connection bar is not visible.
  • Issue #7231 - Don’t strip binaries when packaging them in the server RPM as this might break cpython modules.
  • Issue #7252 - Ensure that Columns should always be visible in the import/export dialog.
  • Issue #7260 - Fixed an issue where an Empty message popup after running a query.
  • Issue #7262 - Ensure that Autocomplete should work after changing the connection.
  • Issue #7294 - Fixed an issue where the copy and paste row does not work if the first column contains no data.
  • Issue #7296 - Ensure that after deleting multiple objects from the properties panel, the browser tree should be refreshed.
  • Issue #7299 - Fixed sorting issue in the statistics panel.
  • Issue #7305 - Fixed an issue where the Dashboard Server Activity was showing old queries as active.
  • Issue #7307 - Fixed an issue where the table showed duplicate columns when creating multiple sequences on the same column.
  • Issue #7308 - Ensure that sorting should be preserved on refresh for Server Activity.
  • Issue #7322 - Fixed an issue while creating a new database throwing an error that failed to retrieve data.
  • Issue #7333 - Fixed an issue where the drag and drop table in ERD throws an error.
  • Issue #7339 - Ensure that the Dashboard column sort order should be remembered when the refresh button is clicked.

New in pgAdmin 4 6.8 (Apr 7, 2022)

  • New features:
  • Added transaction start time to Server activity sessions view.
  • Added support for unique keys in ERD.
  • Support running the container under OpenShift with alternate UIDs.
  • Housekeeping:
  • Port Properties panel for collection node, Dashboard, and SQL panel in React.
  • Port preferences dialog to React.
  • Bug fixes:
  • Fixed an issue where SQL for revoke statements are not shown for databases.
  • Adds a new LDAP authentication configuration parameter that indicates the case sensitivity of the LDAP schema/server.
  • Fixed an issue where the error is shown on logout when the authentication source is oauth2.
  • Fixed an issue where the browser tree state was not preserved correctly.
  • Fixed an issue where foreign key relationships do not update when the primary key is modified.
  • Ensure that the values of certain fields are prettified in the statistics tab for collection nodes.
  • Ensure objects depending on extensions are not displayed in Schema Diff.
  • Fixed an issue where foreign key is not removed even if the referred table is removed in ERD.
  • Fixed an issue where the newly added table is not visible under the Tables node on refresh.
  • Correct typo in the documentation.
  • Fixed schema diff issue where function’s difference DDL was showing incorrectly when arguments had default values with commas.
  • Ensure that the correct user should be selected in the new connection dialog.
  • Fixed schema diff issue in which the option ‘null’ doesn’t appear in the DDL statement for the foreign table.
  • Fixed an issue where unexpected error messages are displayed when users change the language via preferences.
  • Ensure that pgAdmin4 should work with latest jinja2 version.
  • Fixed ‘Cannot read properties of undefined’ error while creating the table via the ERD tool.

New in pgAdmin 4 6.7 (Mar 14, 2022)

  • Security Release:
  • Please note that this release includes a security update to fix an issue where a user could upload files to directories outside of their storage directory, when using pgAdmin running in server mode.
  • Users running pgAdmin in server mode, including the standard container based distribution, should upgrade to this release as soon as possible.
  • This issue does not affect users running in desktop mode.

New in pgAdmin 4 6.6 (Mar 10, 2022)

  • Features:
  • Added capability to deploy PostgreSQL servers on Amazon RDS.
  • This feature allows the users to deploy the PostgreSQL server on the Amazon AWS Cloud. In the future more cloud options will be available.
  • Bugs/Housekeeping:
  • Rename the menu 'Disconnect Database' to 'Disconnect from database'.
  • Fixed a schema diff issue in which user mappings were not compared correctly.
  • Fixed an issue where pgadmin cannot connect to LDAP when STARTTLS is required before bind.
  • Fixed an issue where a warning is flashed every time for an email address when authentication sources are internal and ldap.
  • Fixed an issue where the parent partition table was not displayed during autocomplete.
  • Fixed an issue where the User Management dialog is not opening.
  • Ensure that the user should be able to add a new server with a UNIX socket connection.
  • Allow users to scroll and enter input when there is a validation error.
  • Ensure that Flask-Security-Too is using the latest version.

New in pgAdmin 4 6.4 (Jan 13, 2022)

  • New features:
  • Issue #4803 - Added support to import/export server groups and servers from GUI.
  • Housekeeping:
  • Issue #7018 - Port Restore dialog to React.
  • Issue #7019 - Port Maintenance dialog to React.
  • Bug fixes:
  • Issue #6745 - Fixed an issue where Tablespace is created though an error is shown on the dialog.
  • Issue #7003 - Fixed an issue where Explain Analyze shows negative exclusive time.
  • Issue #7034 - Fixed an issue where Columns with default value not showing when adding a new row.
  • Issue #7075 - Ensure that help should be visible properly for Procedures.
  • Issue #7077 - Fixed an issue where the Owner is not displayed in the reverse engineering SQL for Procedures.
  • Issue #7078 - Fixed an issue where an operation error message pop up showing the database object’s name incorrectly.
  • Issue #7081 - Fixed an issue in SQL generation for PostgreSQL-14 functions.
  • Issue #7093 - Fixed an issue where SubPlans may overlap other nodes & make them inaccessible in Graphical EXPLAIN View.
  • Issue #7096 - Ensure that Truncate and Reset statistics should work.
  • Issue #7102 - Fixed a schema diff issue where generated script adds unwanted line endings for Functions/Procedures/Trigger Functions.

New in pgAdmin 4 6.3 (Dec 16, 2021)

  • New features:
  • Added support for Two-factor authentication for improving security.
  • Added support to disable the auto-discovery of the database servers.
  • Housekeeping:
  • Replace Flask-BabelEx with Flask-Babel.
  • Port Backup Global, Backup Server, and Backup object dialog in React.
  • Replaced alertifyjs notifiers with React-based notistack.
  • Upgrade Flask to version 2.
  • Replace Alertify alert and confirm with React-based model dialog.
  • Bug fixes:
  • Fixed an issue where tooltip data are not displaying on downloaded graphical explain plan.
  • Fixed schema diff owner related issue.
  • Fixed an issue where referenced table drop-down should be disabled in foreign key -> columns after one row is added.
  • Ensure that sort order should be maintained when renaming a server group.
  • Fixed schema diff related some issues.
  • Ensure that the user should be allowed to set the schema of an extension while creating it.
  • Increase the width of the scrollbars.
  • Fixed an issue where the user can’t debug function with timestamp parameter.
  • Fixed an issue where the Change Password menu option is missing for internal authentication source when more than one authentication source is defined.
  • Fixed an issue where On-demand rows throw an error when any row cell is edited and saved it then scroll to get more rows.
  • Ensure that Python 3.10 and the latest eventlet dependency should not break the application.
  • Fix an RPM build issue that could lead to a conflict with python3 at installation.
  • Fixed an issue where the error is thrown while creating a new server using Add New Server from the dashboard while tree item is not selected.
  • Ensure that statue message should not hide the last line of messages when running a long query.
  • Fixed an issue where reverse engineering SQL is wrong for Aggregate.
  • Correct the SQL definition for function/procedure with the Atomic keyword in PG14.
  • Fixed an issue where SQLite database definition is wrong because the USER_ID FK references the table user_old which is not available.
  • Add “section” to the Debian package control files.
  • Update the dropzone version to 5.9.3 and Flask-SQLAlchemy to 2.5.*.
  • Fixed some accessibility issues.
  • Fixed unhashable type issue while opening the about dialog.
  • Ensure that the Owner should not be disabled while creating the procedure.
  • Fixed an issue where confirmation pop-up is hidden behind Reassign/Drop Owned Dialog.

New in pgAdmin 4 6.2 (Nov 18, 2021)

  • New features:
  • Added support of Aggregate and Operator node in view-only mode.
  • Ensure that users should be able to modify the REMOTE_USER environment variable as per their environment by introducing the new config parameter WEBSERVER_REMOTE_USER.
  • Housekeeping:
  • Bug fixes:
  • Fixed pgAdmin freezing issue by providing the error message for the operation that can’t perform due to lock on the particular table.
  • Ensure that columns should be merged if the newly added column is present in the parent table.
  • Fixed an issue where pgAdmin is not opening properly.
  • Ensure that internal authentication when combined with other authentication providers, the order of internal source should not matter while picking up the provider.
  • Ensure that inherit table icon should be visible properly in the tree view.
  • Fixed an issue where properties panel is not updated when any object is added from the browser tree.
  • Ensure that the user should be able to navigate browser tree objects using arrow keys from keyboard.
  • Fixed an issue where database nodes are not getting loaded behind a reverse proxy with SSL.
  • Fixed SQL syntax error if select “Custom auto-vacuum” option and not set Autovacuum option to Yes or No.
  • Fixed an issue where older server group name displayed in the confirmation pop-up when the user removes server group.
  • Fixed an issue where JSON editor preview colours have inappropriate contrast in dark mode.
  • Fixed JSON Editor scrolling issue in code mode.
  • Fixed an issue where user details are not shown when the non-admin user tries to connect to the shared server.
  • Ensure that dialog should be opened when clicking on Reassign/Drop owned menu.
  • Ensure that changing themes should work on Windows when system high contrast mode is enabled.
  • Ensure that the Binary path for PG14 should be visible in the preferences.
  • Added operators and aggregates in search objects.
  • Fixed an issue where textarea should be allowed to resize and have more than 255 chars.
  • Fixed an issue where SQL for index shows the same column multiple times.
  • Reset the layout if pgAdmin4 detects the layout is in an inconsistent state.

New in pgAdmin 4 6.1 (Oct 21, 2021)

  • New features:
  • Issue #4596 - Added support for indent guides in the browser tree.
  • Issue #6081 - Added support for advanced table fields like the foreign key, primary key in the ERD tool.
  • Issue #6241 - Added support to allow tables to be dragged to ERD Tool.
  • Issue #6529 - Added index creation when generating SQL in the ERD tool.
  • Issue #6657 - Added support for authentication via the webserver (REMOTE_USER).
  • Issue #6794 - Added support to enable/disable rules.
  • Housekeeping
  • Bug fixes:
  • Issue #6719 - Fixed OAuth2 integration redirect issue.
  • Issue #6754 - Ensure that query highlighting color in the query tool should be less intensive.
  • Issue #6776 - Changed the label ‘Inherits Tables?’ to ‘Is inherited?’ as it misleading in the properties panel.
  • Issue #6790 - Fixed an issue where the user is unable to create an index with concurrently keyword.
  • Issue #6797 - Remove an extra blank line at the start of the SQL for function, procedure, and trigger function.
  • Issue #6802 - Fixed the issue of editing triggers for advanced servers.
  • Issue #6828 - Fixed an issue where the tree is not scrolling to the object selected from the search result.
  • Issue #6858 - Fixed object delete issue from the properties tab for the collection nodes.
  • Issue #6876 - Ensure that the Dashboard should get updated after connecting to the server.
  • Issue #6881 - Fixed an issue where the browser tree doesn’t show all contents on changing resolution.
  • Issue #6882 - Ensure that columns should be displayed in the order of creation instead of alphabetical order in the browser tree.
  • Issue #6890 - Fixed background colour issue in the browser tree.
  • Issue #6891 - Added support for composite foreign keys in the ERD tool.
  • Issue #6900 - Fixed an issue where exclusion constraint cannot be created from table dialog if the access method name is changed once.
  • Issue #6905 - Fixed an issue where the users are unable to load the databases behind an HTTP reverse proxy.
  • Issue #6908 - Fixed an issue where each click to refresh the collection node, the number of objects decreasing by tens or more.
  • Issue #6912 - Fixed browser tree sort order regression issue.
  • Issue #6915 - Fixed an issue where the blank string is stored instead of NULL in the server table of SQLite database.
  • Issue #6928 - Ensure that the master password should be prompt when MASTER_PASSWORD_REQUIRED is set to True and AUTHENTICATION_SOURCES is webserver.
  • Issue #6929 - Ensure that only the table node should be allowed to drop on the ERD tool.
  • Issue #6930 - Fixed an issue where the existing server group is disappeared on rename it.
  • Issue #6935 - Fixed an issue where the wrong SQL is generated when deleting and renaming table columns together.

New in pgAdmin 4 6.0 (Oct 7, 2021)

  • New features:
  • Added support for OWNED BY Clause for sequences.
  • Housekeeping:
  • Revisit all the CREATE and DROP DDL’s to add appropriate ‘IF EXISTS’, ‘CASCADE’ and ‘CREATE OR REPLACE’.
  • Port browser tree to React.
  • Port object nodes and properties dialogs to React.
  • Port Grant Wizard to react.
  • Remove GPDB support completely.
  • Bug fixes:
  • Fixed an issue where grant wizard is unresponsive if the database size is huge.
  • Added support to create the Partitioned table using COLLATE and opclass.
  • Ensure that in the Query History tab, query details should be scrollable.
  • Fixed an issue where collapse and expand arrows mismatch in case of nested IF.
  • Fixed an issue where the last message is not visible in the Debugger.
  • Updated query error row selection color as per dark theme style guide.
  • Fixed an issue where the drop cascade button enables for Databases.
  • Fixed an issue where Refresh view options are not working for materialized view.
  • Fixed keyerror issue in schema diff for ‘attnum’ and ‘edit_types’ parameter.
  • Ensure that RLS names should not be editable in the collection node of properties tab.
  • Fixed an issue where Execute button of the query tool gets disabled once we change anything in the data grid.
  • Ensure that SQL help should work for EPAS servers.

New in pgAdmin 4 5.7 (Sep 9, 2021)

  • New features:
  • Added support for the truncate table with restart identity.
  • Make code folding case insensitive in the code mirror.
  • Added database and server information on the Maintenance process watcher dialog.
  • Allow the referenced table to be the same as the local table in one to many relationship for ERD Tool.
  • Make closing tabs to be smarter by focusing on the appropriate tab when the user closed a tab.
  • Set PSQLRC and PSQL_HISTORY env vars to apt. user storage path in the server mode.
  • Housekeeping:
  • Bug fixes:
  • Fixed an issue where privileges were revoked using SQL query on objects like tables that do not correctly show in SQL tab.
  • Fixed an issue where the user can not paste the updated table header in safari 12 and 13 browsers.
  • Ensure that trigger function SQL should have ‘create or replace function’ instead of ‘create function’ only.
  • Fixed blank screen issue on windows and also made changes to use NWjs manifest for remembering window size.
  • Fixed the export image issue where relation lines are over the nodes.
  • Fixed width limitation issue in PSQL tool window.
  • Fixed an issue where columns with sequences get altered unnecessarily with a schema diff tool.
  • Ensure that the lock panel should not be blocked for larger records.
  • Partially fixes the data output panel display issue.
  • Fixed an issue where whitespace in function bodies was not applied while generating the script using Schema Diff.
  • Introduced OAUTH2_SCOPE variable for the Oauth2 scope configuration.
  • Enables pgAdmin to retrieve user permissions in case of nested roles which helps to terminate the session for AWS RDS.
  • Fixed no attribute ‘_asdict’ error when connecting the database server.
  • Fixed errors related to HTML tags shown in the error message for JSON editor.
  • Fixed UnboundLocalError where local variable ‘user_id’ referenced before assignment.
  • Renamed ‘Auto rollback?’ to ‘Auto rollback on error?’.
  • Fixed the JSON editor issue of hiding the first record.
  • Ensure that deleting a database should not automatically connect to the next database.
  • Ensure that pgAdmin should not fail at login due to a special character in the hostname.
  • Fixed an issue where multiple query tool tabs getting closed for the single close event.

New in pgAdmin 4 5.6 (Aug 12, 2021)

  • New features:
  • Added support to copy SQL from main window to query tool.
  • Added support for formatted JSON viewer/editor when interacting with data in a JSON column.
  • Housekeeping:
  • Rename the “Resize by data?” to “Columns sized by” and disabled the ‘Maximum column width’ button if ‘Columns sized by’ is set to ‘Column data’.
  • Bug fixes:
  • Ensure that the login account should be locked after N number of attempts. N is configurable using the ‘MAX_LOGIN_ATTEMPTS’ parameter.
  • Fixed CSRF errors for stale sessions by increasing the session expiration time for desktop mode.
  • Fixed an issue in the search object when searching in ‘all types’ or ‘subscription’ if the user doesn’t have access to the subscription.
  • Fixed an issue where paste is not working through Right-Click option on PSQL.
  • Fixed TypeError ‘NoneType’ object is not sub scriptable.
  • Fixed incorrect tablespace options in the drop-down for move objects dialog.
  • Fixed an issue where the titles in query tabs are different.
  • Fixed incorrect binary path issue when the user deletes the binary path from the preferences.
  • Ensure that all the required options should be loaded when the Range data type is selected while creating a custom data type.
  • Fixed dashboard server activity issue when active_since parameter is None.
  • Fixed an issue where even if the user is locked, he can reset the password and can login into pgAdmin.

New in pgAdmin 4 5.5 (Jul 15, 2021)

  • New features:
  • Issue #1975 - Highlighted long running queries on the dashboards.
  • Issue #3893 - Added support for Reassign/Drop Owned for login roles.
  • Issue #3920 - Do not block the query editor window when running a query.
  • Issue #5940 - Added support for OAuth 2 authentication.
  • Issue #6559 - Added option to provide maximum width of the column when ‘Resize by data?’ option in the preferences is set to True.
  • Housekeeping:
  • Bug fixes:
  • Issue #4189 - Ensure that the Data Output panel can be snapped back after it is detached.
  • Issue #6388 - Fixed replace keyboard shortcut issue in the query tool on the normal keyboard layout.
  • Issue #6398 - Fixed an issue where detaching the query editor panel gives a blank white panel.
  • Issue #6427 - Remove leading whitespace and replace it with ‘[…] ‘ in the Query Tool data grid so cells don’t look empty.
  • Issue #6448 - Fixed an issue in the search object when searching in ‘all types’ or ‘subscription’ if the user doesn’t have access to the subscription.
  • Issue #6489 - Fixed an issue where Execute/Refresh button should not be disabled when we run the empty query.
  • Issue #6505 - Fixed an issue where the New Connection Drop Down has lost default maintenance database, auto-select, and tab-through functionality.
  • Issue #6536 - Fixed directory selection issue with the folder dialog.
  • Issue #6541 - Ensure that setting ‘Open in new browser tab’ should be visible, it should not be based on the value of ‘ENABLE_PSQL’.
  • Issue #6547 - Fixed copy/paste issues for PSQL tool terminal.
  • Issue #6550 - Disable email deliverability check that was introduced in flask-security-too by default to maintain backwards compatibility.
  • Issue #6555 - Fixed Czech translation string for ‘Login’ keyword.
  • Issue #6557 - Fixed an issue where incorrect column name listed in the properties of Index.

New in pgAdmin 4 5.4 (Jun 17, 2021)

  • New features:
  • Issue #1561 - Added browse button to select the binary path in the Preferences.
  • Issue #1591 - Added Grant Wizard option under Package node.
  • Issue #2341 - Added support to launch PSQL for the connected database server.
  • Issue #4064 - Added window maximize/restore functionality for properties dialog.
  • Issue #5370 - Added support to set the binary path for the different database server versions.
  • Issue #6231 - Added OS, Browser, Configuration details in the About dialog.
  • Issue #6395 - Added support for rotating the pgAdmin log file on the basis of size and age.
  • Issue #6524 - Support non-admin installation on Windows.
  • Housekeeping:
  • Issue #4622 - Added RESQL/MSQL test cases for Table and its child nodes.
  • Issue #6225 - Updated Flask-Security-Too to the latest v4.
  • Issue #6460 - Added a mechanism to detect a corrupt/broken config database file.
  • Bug fixes:
  • Issue #4203 - Fixed the issue of renaming the database by another user.
  • Issue #6404 - Ensure that the Query Tool connection string should not be changed as per the ‘Query Tool tab title’.
  • Issue #6466 - Ensure that the user should be able to add members in Login/Role group while creating it.
  • Issue #6469 - Ensure that the calendar control should be disabled in the properties panel for Role.
  • Issue #6473 - Disable browser password saving in the runtime.
  • Issue #6478 - Fixed duplicate SQL issue for tables with more than one partition.
  • Issue #6482 - Fixed an issue where the Foreground Color property of server dialog does not work.
  • Issue #6513 - Fixed an issue where pgAdmin does not open after password reset in server mode.
  • Issue #6520 - Fixed an issue where a decimal number is appended for character varying fields while downloading the data in CSV format.

New in pgAdmin 4 5.3 (May 20, 2021)

  • New features:
  • Issue #5954 - Added support to set auto width of columns by content size in the data output window.
  • Issue #6158 - Added support to connect PostgreSQL servers via Kerberos authentication.
  • Issue #6397 - Added “IF NOT EXISTS” clause while creating tables and partition tables which is convenient while using the ERD tool.
  • Bug fixes:
  • Issue #4436 - Fixed an issue where drag and drop object is not correct in codemirror for properties dialog.
  • Issue #5477 - Added support for cache bust webpack chunk files.
  • Issue #5555 - Fixed an issue where data is displayed in the wrong order when executing the query repeatedly.
  • Issue #5776 - Ensure that while connecting to the server using SSPI login, it should not prompt for the password.
  • Issue #6329 - Fixed an issue where the wrong SQL is showing for the child partition tables.
  • Issue #6341 - Fixed an issue where CSV download quotes the numeric columns.
  • Issue #6355 - Ensure that pgAdmin should not allow opening external files that are dragged into it.
  • Issue #6377 - Fixed an issue where schema diff does not create DROP DEFAULT statement for columns.
  • Issue #6385 - Ensure that Backup and Restore should work on shared servers.
  • Issue #6392 - Fixed an issue where the filter ‘Include/Exclude By Selection’ not working for null values.
  • Issue #6399 - Ensure that the user should not be able to add duplicate panels.
  • Issue #6407 - Added support for the creation of Nested Table and Varying Array Type for Advanced Server.
  • Issue #6408 - Fixed ModuleNotFoundError when running setup.py from outside of the root.
  • Issue #6409 - Fixed an issue where the current debug line is not visible in the ‘Dark’ theme.
  • Issue #6413 - Fixed an issue where duplicate columns are visible in the browser tree, which is owned by two sequences.
  • Issue #6414 - Fixed an issue where the Help message not displaying correctly on Login/Group role.
  • Issue #6416 - Added comment column in the properties panel for View and Materialized View collection node.
  • Issue #6417 - Fixed an issue where query editor is not being closed if the user clicks on the ‘Don’t Save’ button.
  • Issue #6420 - Ensure that pgAdmin4 shut down completely on the Quit command.
  • Issue #6443 - Fixed an issue where file dialog showing incorrect files for the selected file types.
  • Issue #6444 - Fixed an issue where the user is not warned if Kerberos ticket expiration is less than 30 min while initiating a global backup.
  • Issue #6445 - Ensure that proper identification should be there when the server is connected using Kerberos or without Kerberos.

New in pgAdmin 4 5.2 (Apr 22, 2021)

  • New features:
  • Housekeeping:
  • Issue #5319 - Improve code coverage and API test cases for Server module.
  • Bug fixes:
  • Issue #4001 - Updated docs and screenshots to cover the Notifications tab on the Query Tool.
  • Issue #5519 - Ensure that the query tool tab should be closed after server disconnection when auto-commit/auto-rollback is set to false.
  • Issue #5908 - Fixed an issue where shortcut keys are not working with manage macro.
  • Issue #6076 - Fixed an issue where correct error not thrown while importing servers and JSON file has incorrect/insufficient keys.
  • Issue #6082 - Ensure that the user should not be to change the connection when a long query is running.
  • Issue #6106 - Fixed flickering issue of the input box on check constraints.
  • Issue #6161 - Fixed an issue where the cursor shifts its focus to the wrong window for all the query tool related model dialogs.
  • Issue #6220 - Corrected the syntax for ‘CREATE TRIGGER’, use ‘EXECUTE FUNCTION’ instead of ‘EXECUTE PROCEDURE’ from v11 onwards.
  • Issue #6274 - Ensure that the strings in the LDAP auth module are translatable.
  • Issue #6293 - Fixed an issue where the procedure creation is failed when providing the Volatility option.
  • Issue #6306 - Fixed an issue while selecting the row which was deleted just before the selection operation.
  • Issue #6325 - Ensure that the file format for the storage manager should be ‘All files’ and for other dialogs, it should remember the last selected format.
  • Issue #6327 - Ensure that while comparing domains check function dependencies should be considered in schema diff.
  • Issue #6333 - Fixed sizing issue of help dialog for Query Tool and ERD Tool when open in the new browser tab.
  • Issue #6334 - Fixed SQL panel black screen issue when detaching it in runtime.
  • Issue #6338 - Added missing dependency ‘xdg-utils’ for the desktop packages in RPM and Debian.
  • Issue #6344 - Fixed cannot unpack non-iterable response object error when selecting any partition.
  • Issue #6356 - Mark the Apache HTTPD config file as such in the web DEB and RPM packages.
  • Issue #6367 - Fixed an issue where the Save button is enabled by default when open the table’s properties dialog on PG 9.5.
  • Issue #6375 - Fixed an issue where users are unable to see data of the partitions using the View/Edit data option.
  • Issue #6376 - Fixed an issue where a connection warning should be displayed on the user clicks on explain or explain analyze and the database server is disconnected from the browser tree.
  • Issue #6379 - Fixed an issue where foreign data wrapper properties are not visible if the host option contains two host addresses.
  • Issue #6385 - Ensure that Backup and Restore should work on shared servers.

New in pgAdmin 4 5.1 (Mar 25, 2021)

  • New features:
  • Issue #5404 - Show the login roles that are members of a group role be shown when examining a group role.
  • Issue #6212 - Make the container distribution a multi-arch build with x86_64 and Arm64 support.
  • Issue #6268 - Make ‘kerberos’ an optional feature in the Python wheel, to avoid the need to install MIT Kerberos on the system by default.
  • Issue #6270 - Added ‘–replace’ option in Import server to replace the list of servers with the newly imported one.
  • Issue #6271 - Added zoom scaling options with keyboard shortcuts in runtime.
  • Housekeeping:
  • Issue #3976 - Use schema qualification while accessing the catalog objects.
  • Issue #6176 - Make the ‘Save Data Changes’ icon to be more intuitive.
  • Bug fixes:
  • Issue #4014 - Fixed alignment issue under preferences for the German language.
  • Issue #4020 - Fixed color issue on the statistics tab for collection node in the safari browser.
  • Issue #4438 - Fixed an issue where adding/updating records fails if the table name contains percent sign.
  • Issue #4784 - Ensure that autovacuum and analyze scale factors should be editable with more than two decimals.
  • Issue #4847 - Fixed an issue where % displayed twice in explain analyze for query and table.
  • Issue #4849 - Rename text ‘table’ with ‘relation’ in the statistic tab for explain analyze.
  • Issue #4959 - Fixed an issue where the properties tab for collection nodes is unresponsive after switching the tabs.
  • Issue #5073 - Fixed an issue where the Save button is enabled for functions/procedures by default when open the properties dialog.
  • Issue #5119 - Fixed an issue where hanging symlinks in a directory cause select file dialog to break.
  • Issue #5467 - Allow underscores in the Windows installation path.
  • Issue #5628 - Remove the “launch now” option in the Windows installer, as UAC could cause it to run as an elevated user.
  • Issue #5810 - Ensure that cell content being auto selected when editing the cell data.
  • Issue #5869 - Ensure that SQL formatter should not add extra tabs and format the SQL correctly.
  • Issue #6018 - Fixed encoding issue when database encoding set to SQL_ASCII and name of the column is in ASCII character.
  • Issue #6159 - Ensure that the user should be able to kill the session from Dashboard if the user has a ‘pg_signal_backend’ role.
  • Issue #6206 - Ensure that the view/edit data panel should not be opened for unsupported nodes using the keyboard shortcut.
  • Issue #6227 - Ensure PGADMIN_DEFAULT_EMAIL looks sane when initialising a container deployment.
  • Issue #6228 - Improve the web setup script for Linux to make the platform detection more robust and overrideable.
  • Issue #6233 - Ensure that SQL formatter should not use tab size if ‘Use spaces?’ set to false.
  • Issue #6253 - Fixed an issue where the user is unable to create a subscription if the host/IP address for connection is 127.0.0.1.
  • Issue #6259 - Ensure that proper error message should be shown on the properties and statistics tab in case of insufficient privileges for a subscription.
  • Issue #6260 - Fixed an issue where the ‘Create Slot’ option is disabled in case of the same IP/host provided but the port is different.
  • Issue #6269 - Ensure the Python interpreter used by the runtime ignores user site-packages.
  • Issue #6272 - Fixed an issue where the user is not able to change the connection in Query Tool when any SQL file is opened.
  • Issue #6279 - Ensure that the venv activation scripts have the correct path in them on Linux.
  • Issue #6281 - Fixed an issue where schema diff showing wrong SQL when comparing triggers with different when clause.
  • Issue #6286 - Ensure that the template database should be visible while creating the database.
  • Issue #6292 - Fixed string index out of range error where the dependent tab is in focus and selecting any publication or table.
  • Issue #6294 - Fixed an issue where the dependent tab throwing an error when selecting any login/group role.
  • Issue #6307 - Fixed an issue where the incorrect values visible in the dependents tab for publication.
  • Issue #6312 - Fixed an issue where copy/paste rows in view data paste the wrong value for boolean type.
  • Issue #6316 - Ensure that the primary key should be visible properly in the table dialog.
  • Issue #6317 - Ensure that toggle buttons are accessible by most screen readers.
  • Issue #6322 - Fixed an issue where the top menu disappears when entering into the full screen for minimum screen resolution.
  • Issue #6323 - Ensure that the grantor name should be visible properly for the security tab in the table dialog.

New in pgAdmin 4 5.00 (Feb 25, 2021)

  • Features:
  • New Desktop Runtime (Using NWjs):
  • The Desktop Runtime is now based on NWjs which integrates a browser and the Python server creating a standalone application. By implementing it using NWjs we get rid of the separate server application and the independent browser. We also get rid of QT and C++ runtime logic.
  • There are two minor known issues with this feature (6255 and 6258), both of which are due to bugs in NWjs itself; Users on macOS should use the application menu to exit pgAdmin, rather than quitting from the Dock icon to avoid the first issue. The second issue may cause Windows users to see a red square instead of the normal application icon in some circumstances.
  • Logical Replication support:
  • Logical replication uses a publish and subscribe model with one or more subscribers subscribing to one or more publications on a publisher node. We have added support for logical replication by introducing new treeview nodes and dialogues with which users can easily create/alter/delete publications and subscriptions. Support is also included in the Schema Diff tool.
  • Quick Search functionality:
  • Added a quick search option in the Help menu to search menu items and help articles. Type at least three characters to display all the matching possibilities under Menu items and the relevant documents under Help articles.
  • Make Statistics, Dependencies, Dependants tabs closable. Users can add them back using the 'Add panel' option on the context menu for the tab strip.
  • When running in Docker/Kubernetes, ensure logs are not stored in the container, and only sent to the console.
  • Bugs/Housekeeping:
  • Use cheroot as the default production server for pgAdmin4.
  • Updated Javascript dependencies to the latest versions.
  • Fixed an issue where the focus is not properly set on the filter text editor after closing the error dialog.
  • Fixed an issue where the dependencies tab shows multiple owners for the objects having shared dependencies.
  • Fixed an issue where the Zoom to fit button in the ERD Tool only works if the diagram is larger than the canvas.
  • Fixed an issue where the user was unable to change the background color for a server.
  • Fixed an issue where external utility jobs (backup, maintenance etc.) are failing when the log level is set to DEBUG.
  • Ensure DEB/RPM packages depend on the same version of each other.
  • Fixed an autocomplete issue where it is not showing any suggestions if the schema name contains escape characters.

New in pgAdmin 4 4.30 (Jan 28, 2021)

  • New features:
  • Added ERD Diagram support with basic table fields, primary key, foreign key, and DDL SQL generation.
  • Added support for Kerberos authentication, using SPNEGO to forward the Kerberos tickets through a browser.
  • Documentation of Kerberos support.
  • Documentation of ERD Diagram support.
  • Add a container option (PGADMIN_DISABLE_POSTFIX) to disable the Postfix server.
  • Housekeeping:
  • Improve code coverage and API test cases for pgAgent.
  • Added connected pgAdmin user and connection name in the log file.
  • Updated mimetype from ‘text/javascript’ to ‘application/javascript’ as ‘text/javascript’ is obsolete.
  • Include PostgreSQL 13 utilities in the container.
  • Bug fixes:
  • Added ‘Count Rows’ option to the partition sub tables.
  • Improve the explain plan details by showing popup instead of tooltip on clicking of the specified node.
  • Added support for expression in exclusion constraints.
  • Fixed incorrect log information for AUTHENTICATION_SOURCES.
  • Ensure that the ‘template1’ database should not be visible after pg_upgrade.
  • Fixed an issue where the Save button is enabled by default in Macro.
  • Remove extra line after Manage Macros menu while clearing all macros.
  • Ensure that ‘Clear All Rows’ should not work if there is no existing macro available and the user does not specify any value.
  • Fixed an issue where the server is disconnected error message displayed if the user creates Macro with invalid SQL.
  • Ensure that the macro query result should be download properly.
  • Added appropriate help message and a placeholder for letting users know about the account password expiry for Login/Group Role.
  • Updated Flask-BabelEx to the latest.
  • Fixed an issue where the state of the Save File icon does not match the dirty editor indicator.
  • Fixed an issue where the dirty indicator stays active even if all changes were undone.
  • Ensure that the rename panel should be disabled when the SQL file opened in the query tool.
  • Fixed extra parentheses issue around joins for Views.
  • Fixed accessibility issues in schema diff module.
  • Fixed an issue on refreshing files in Query Tool.
  • Fixed an issue where Non-admin user is unable to view shared server created using service.
  • Fixed accessibility issues in various dialogs.
  • Fixed TypeError exception in schema diff when selected any identical object.
  • Updated deployment documentation, refer correctly to uWSGI where Gunicorn had been referenced.
  • Fixed an issue of deleting records when the user tries to delete multiple records.
  • Ensure that the user should be able to specify an older date for the account expiration of the role/user.
  • Fixed an issue where the database list in the new connection window is not visible.
  • Added informative message when there is no difference found for schema diff.
  • Fixed an issue where sequences are not created.
  • Ensure that verbose logs should be visible for Utility(Backup, Maintenance) jobs.
  • Ensure that the current value of the sequence should be ignored while comparing using schema diff.

New in pgAdmin 4 4.29 (Jan 28, 2021)

  • New features:
  • Housekeeping
  • Improve code coverage and API test cases for Foreign Tables.
  • Improve code coverage and API test cases for Views and Materialized Views.
  • Improve code coverage and API test cases for Debugger.
  • Update the cryptography python package for Python 3.5 and above.
  • Ensure that code coverage should cover class and function declarations.
  • Bug fixes:
  • Fixed false error is shown while adding a new foreign key from the table dialog when a foreign key already exists with Auto FK Index set to true.
  • Ensure that folder rename should work properly in Storage Manager.
  • Fixed an issue where the debugger’s custom tab title not applied when opened in the new browser tab.
  • Fixed an issue where dynamic tab title has not applied the first time for debugger panel.
  • Fixed documentation issue where JSON is not valid.
  • Added the appropriate server icon based on the server type in the new connection dialog.
  • Fixed an issue where the process watcher dialog throws an error for the database server which is already removed.
  • Ensure that dirty indicator (*) should not be visible when renaming the tabs.
  • Fixed an issue where escape character is shown when the server/database name has some special characters.
  • Fixed an issue where schema diff doesn’t show the result of compare if source schema has tables with RLS.
  • Fixed an issue where an illegal argument is showing for trigger SQL when a trigger is created for View.
  • Fixed an issue where shared servers import is failing.
  • Fixed DLL load failed while importing bcrypt.

New in pgAdmin 4 4.28 (Nov 12, 2020)

  • New features:
  • Added support to download utility files at the client-side.
  • Added support to rename query tool and debugger tabs title.
  • Added support for dynamic tab size.
  • Added tab title placeholder for Query Tool, View/Edit Data, and Debugger.
  • Added support to compare schemas and databases in schema diff.
  • Housekeeping:
  • Issue #5938 - Documentation of Storage Manager.
  • Bug fixes:
  • Ensure that some fields should be disabled for the trigger in edit mode.
  • Fixed an issue where the validation error message is shown twice.
  • Ensure that non-superuser should be able to debug the function.
  • Ensure that query history should be listed by date/time in descending order.
  • Ensure that search object functionality works with case insensitive string.
  • Fixed an issue where the suffix for Toast table size is not visible in the Statistics tab.
  • Ensure that macros should be run on the older version of Safari and Chrome.
  • Fixed an issue where a mismatch in the value of ‘Estimated row’ for functions.
  • Added security related enhancements.
  • Fixed an issue where non-closeable tabs are getting closed.
  • Fixed an issue where a long file name is not visible on the process watcher dialog.
  • Fixed an issue where connection to the server is on wait state if a different user is provided.
  • Ensure that Grant Wizard should include foreign tables.

New in pgAdmin 4 4.27 (Oct 15, 2020)

  • New features:
  • Issue #1402 - Added Macro support.
  • Issue #2519 - Added support to view trigger function under the respective trigger node.
  • Issue #3794 - Allow user to change the database connection from an open query tool tab.
  • Issue #5200 - Added support to ignore the owner while comparing objects in the Schema Diff tool.
  • Issue #5857 - Added documentation for Macro support.
  • Housekeeping:
  • Issue #5330 - Improve code coverage and API test cases for Functions.
  • Issue #5395 - Added RESQL/MSQL test cases for Functions.
  • Issue #5497 - Merged the latest code of ‘pgcli’ used for the autocomplete feature.
  • Bug fixes:
  • Issue #4806 - Added useful message when the explain plan is not used and empty.
  • Issue #4855 - Fixed an issue where file extension is stripped on renaming a file.
  • Issue #5131 - Ensure that ‘ctrl + a’ shortcut does not move the cursor in SQL editor.
  • Issue #5417 - Fixed and improve API test cases for the schema diff tool.
  • Issue #5739 - Ensure that the import/export feature should work with SSH Tunnel.
  • Issue #5802 - Remove maximum length on the password field in the server dialog.
  • Issue #5807 - Fixed an issue where a column is renamed and then removed, then the drop SQL query takes the wrong column name.
  • Issue #5826 - Fixed an issue where schema diff is showing identical table as different due to default vacuum settings.
  • Issue #5830 - Fixed reverse engineering SQL where parenthesis is not properly arranged for View/MView definition.
  • Issue #5835 - Fixed ‘can’t execute an empty query’ message if the user change the option of Auto FK Index.
  • Issue #5839 - Ensure that multiple extensions can be dropped from the properties tab.
  • Issue #5841 - Fixed an issue where the server is not able to connect using the service.
  • Issue #5843 - Fixed an issue where the ‘PARALLEL UNSAFE’ option is missing from reverse engineering SQL of function/procedure.
  • Issue #5845 - Fixed an issue where the query tool is not fetching more than 1000 rows for the table does not have any primary key.
  • Issue #5853 - Fixed an issue where ‘Rows X’ column values were not visible properly for Explain Analyze in Dark theme.
  • Issue #5855 - Ensure that the user should be able to change the start value of the existing sequence.
  • Issue #5861 - Ensure that the ‘Remove Server’ option should be visible in the context menu.
  • Issue #5867 - Fixed an issue where some properties are not being updated correctly for the shared server.
  • Issue #5882 - Fixed invalid literal issue when fetching dependencies for Materialized View.
  • Issue #5885 - Fixed an issue where the user is unable to change the macro name.

New in pgAdmin 4 4.26 (Oct 15, 2020)

  • New features:
  • Issue #2042 - Added SQL Formatter support in Query Tool.
  • Issue #4059 - Added a new button to the query tool toolbar to open a new query tool window.
  • Issue #4979 - Added shared server support for admin users.
  • Issue #5772 - Warn the user when connecting to a server that is older than pgAdmin supports.
  • Housekeeping:
  • Issue #5332 - Improve code coverage and API test cases for Columns and Constraints (Index, Foreign Key, Check, Exclusion).
  • Issue #5344 - Improve code coverage and API test cases for Grant Wizard.
  • Issue #5774 - Improve code coverage and API test cases for Tables.
  • Issue #5792 - Added documentation for shared server support.
  • Bug fixes:
  • Issue #4216 - Ensure that schema names starting with ‘pg’ should be visible in browser tree when standard_conforming_strings is set to off.
  • Issue #5426 - Adjusted the height of jobstep code block to use maximum space.
  • Issue #5652 - Modified the ‘Commit’ and ‘Rollback’ query tool button icons.
  • Issue #5722 - Ensure that the user should be able to drop the database even if it is connected.
  • Issue #5732 - Fixed some accessibility issues.
  • Issue #5734 - Update the description of GIN and GiST indexes in the documentation.
  • Issue #5746 - Fixed an issue where –load-server does not allow loading connections that use pg_services.
  • Issue #5748 - Fixed incorrect reverse engineering SQL for Foreign key when creating a table.
  • Issue #5751 - Enable the ‘Configure’ and ‘View log’ menu option when the server taking longer than usual time to start.
  • Issue #5754 - Fixed an issue where schema diff is not working when providing the options to Foreign Data Wrapper, Foreign Server, and User Mapping.
  • Issue #5764 - Fixed SQL for Row Level Security which is incorrectly generated.
  • Issue #5765 - Fixed an issue in the query tool when columns are having the same name as javascript object internal functions.
  • Issue #5766 - Fixed string indices must be integers issue for PostgreSQL < 9.3.
  • Issue #5773 - Fixed an issue where the application ignores the fixed port configuration value.
  • Issue #5775 - Ensure that ‘setup-web.sh’ should work in Debian 10.
  • Issue #5779 - Remove illegal argument from trigger function in trigger DDL statement.
  • Issue #5794 - Fixed excessive CPU usage by stopping the indefinite growth of the graph dataset.
  • Issue #5815 - Fixed an issue where clicking on the ‘Generate script’ button shows a forever spinner due to pop up blocker.
  • Issue #5816 - Ensure that the ‘CREATE SCHEMA’ statement should be present in the generated script if the schema is not present in the target database.
  • Issue #5820 - Fixed an issue while refreshing Resource Group.
  • Issue #5833 - Fixed an issue where custom sequences are not visible when show system objects are set to false.
  • Issue #5834 - Ensure that the ‘Remove Server Group’ option is available in the context menu.

New in pgAdmin 4 4.25 (Oct 15, 2020)

  • New features:
  • Issue #3904 - Replace charting library Flotr2 with ChartJS using React.
  • Issue #5126 - Modified schema diff tool to compare two databases instead of two schemas.
  • Issue #5610 - Add a –yes command line option to setup-web.sh to allow non-interactive use.
  • Housekeeping:
  • Issue #5324 - Improve code coverage and API test cases for Foreign Servers and User Mappings.
  • Issue #5327 - Improve code coverage and API test cases for Schemas.
  • Issue #5336 - Improve code coverage and API test cases for Types.
  • Issue #5700 - Remove old Python 2 compatibility code.
  • Issue #5731 - Upgrade font awesome from v4 to v5.
  • Bug fixes:
  • Issue #3767 - Ensure that the original file format should be retained when saving the same file in SQL editor.
  • Issue #3791 - Added missing comments in reverse engineering SQL for each column of a View.
  • Issue #4123 - Fixed an issue where debugger doesn’t work if the search path is set other than ‘public’.
  • Issue #4361 - Fixed ssh tunnel hang issue when the user tries to disconnect the server.
  • Issue #4387 - Fixed an issue where the user is not able to insert the data if the table and columns name contains special characters.
  • Issue #4810 - Fixed an issue where the user is not able to save the new row if the table is empty.
  • Issue #5429 - Ensure that the Dictionaries drop-down shows all the dictionaries in the FTS configuration dialog.
  • Issue #5490 - Make the runtime configuration dialog non-modal.
  • Issue #5526 - Fixed an issue where copying and pasting a cell with multiple line data will result in multiple rows.
  • Issue #5567 - Fixed an issue where conversion of bytea to the binary string results in an error.
  • Issue #5604 - Fixed an issue where the entire logs is in red text when the user runs backup and restore.
  • Issue #5632 - Ensure that the user will be able to modify the start value of the Identity column.
  • Issue #5646 - Ensure that RLS Policy node should be searchable using search object.
  • Issue #5664 - Fixed an issue where ‘ALTER VIEW’ statement is missing when the user sets the default value of a column for View.
  • Issue #5670 - Fixed an issue where the error message does not have a close button on utility dialogs.
  • Issue #5689 - Added the ‘ORDER BY’ clause for the privileges type to fix schema diff issue.
  • Issue #5708 - Correct TLS certificate filename in the container deployment docs.
  • Issue #5710 - Fixed an issue when comparing the table with a trigger throwing error in schema diff.
  • Issue #5713 - Corrected DROP SQL syntax for catalog.
  • Issue #5716 - Fixed an issue where ajax call continues to fire even after disconnecting the database server.
  • Issue #5724 - Clarify some of the differences when running in server mode in the docs.
  • Issue #5730 - Resolve schema diff dependencies by selecting the appropriate node automatically and maintain the order in the generated script.

New in pgAdmin 4 4.24 (Jul 23, 2020)

  • Notable changes in this release include:
  • Support configuration files that are external to the application installation.
  • Added support for LDAP authentication with different DN by setting the dedicated user for the LDAP connection.
  • Added support for schema level restriction.
  • Added RLS Policy support in Schema Diff.
  • Added support for permissive/restricted policy type while creating RLS Policy.
  • Added support for LDAP anonymous binding.
  • Added High Contrast theme support.
  • Added missing dependencies/dependent and corrected some wrongly identified.
  • Replace the runtime themes with ones that don't have sizing issues.
  • Fixed tab indent issue on a selection of lines is deleting the content when 'use spaces == true' in the preferences.
  • Fixed CSRF errors when pgAdmin opened in an iframe on safari browser.

New in pgAdmin 4 4.22 (Jun 25, 2020)

  • Show the startup log as well as the server log in the runtime's log viewer.
  • Implement Selenium Grid to run multiple tests across different browsers, operating systems, and machines in parallel.
  • Remove support for Python 2.
  • Ensure that maintenance job should be worked properly for indexes under a materialized view.
  • Ensure that file browse "home" button should point to $HOME rather than /.
  • Fixed data truncation issue when updating the data of type character with length
  • Fixed generated SQL issue for auto vacuum options.
  • Fixed internal server error when clicking on Triggers -> 'Enable All' for partitions
  • Fixed the SQL help issue for EDB Postgres Advanced Server.
  • Fixed an issue where if LDAP_SEARCH_BASE_DN is not set then, the value for LDAP_BASE_DN will be considered.
  • Improve code coverage and API test cases for Indexes, Rules, Triggers and Compound Triggers.

New in pgAdmin 4 4.21 (Apr 30, 2020)

  • Added LDAP authentication support.
  • Added search object functionality.
  • Added support of Foreign Tables, Packages, Sequences and Synonyms to the Schema Diff.
  • Warn the user if an unsupported, deprecated or unknown browser is detected.
  • Added multiple drop/delete functionality for the table constraints.
  • Fixed copy-paste row issues in View/Edit Data.
  • Added dark mode support for the configuration dialog on Windows/macOS runtime.
  • Added alert message to Reset Layout if any of the panels from Query Tool failed to load.
  • Fixed an issue when the user performs refresh on a large size materialized view.
  • Ensure that default sort order should be using the primary key in View/Edit data.
  • Fixed an issue where changing the values of columns with JSONB or JSON types to NULL
  • Ensure that if the delimiter is set other than comma then download the file as '.txt' file.

New in pgAdmin 4 4.20 (Apr 2, 2020)

  • Added support of Collation, FTS Configuration, FTS Dictionary, FTS Parser and FTS Template to the Schema Diff.
  • Added support of Domain, Domain Constraints and Types to the Schema Diff.
  • Added and fixed gettext usage for better translation coverage.
  • Improve logic to get the DDL statements as a part of the comparison.
  • Enhance the color of switch control for both light and dark theme.
  • Change some colors and opacity to comply with WCAG color contrast standards.
  • Fixed tab key navigation issue for Grant Wizard.
  • Fix an issue where the user can not change the value of DateTime picker control using keyboard.

New in pgAdmin 4 4.19 (Mar 5, 2020)

  • Added Python 3.8 support.
  • Added accessibility support in AlertifyJS.
  • Added Czech language support.
  • Improvements in the UI for both default and dark themes.
  • Fix an issue where debugger not showing all arguments anymore after hitting SQL error while debugging.
  • Ensure that all the transactions should be canceled before closing the connections when a server is disconnected using pgAdmin.
  • Fixed Firefox monospaced issue by updating the font to the latest version.
  • Improve the style of the highlighted code after query execution for Dark mode.
  • Changed background pattern for geometry viewer to use #fff for all themes.

New in pgAdmin 4 4.18 (Feb 6, 2020)

  • New features:
  • Issue #2554 - Added support for a multi-level partitioned table.
  • Issue #3452 - Added a Schema Diff tool to compare two schemas and generate a diff script.
  • Issue #4762 - Allow screen-reader to read label & description of non-textable elements.
  • Issue #4763 - Allow screen-reader to identify the alert errors.
  • Issue #4770 - Added labels and titles after parsing and validating all the pgAdmin4 web pages for accessibility.
  • Issue #4993 - Set input controls as read-only instead of disabled will allow tab navigation in the properties tab and also allow screen readers to read it.
  • Housekeeping:
  • Issue #5049 - Improve code coverage and API test cases for the CAST module.
  • Issue #5050 - Improve code coverage and API test cases for the LANGUAGE module.
  • Issue #5071 - Improve the test framework to run for multiple classes defined in a single file.
  • Issue #5072 - Updated wcDocker package which includes aria-label accessibility improvements.
  • Issue #5096 - Replace node-sass with sass for SCSS compilation.
  • Bug fixes:
  • Issue #3812 - Ensure that path file name should not disappear when changing ext from the dropdown in file explorer dialog.
  • Issue #4410 - Fixed an issue while editing char[] or character varying[] column from View/Edit data throwing an error.
  • Issue #4511 - Fixed an issue where Grant wizard unable to handle multiple objects when the query string parameter exceeds its limit.
  • Issue #4601 - Added tab navigation on close buttons for all the panels and create/properties dialog.
  • Issue #4827 - Fix column resizable issue in the file explorer dialog.
  • Issue #5000 - Logout the pgAdmin session when no user activity of mouse move, click or keypress.
  • Issue #5025 - Fix an issue where setting STORAGE_DIR to empty should show all the volumes on Windows in server mode.
  • Issue #5065 - Updated the incorrect icon used for the cast node on refresh.
  • Issue #5066 - Fix an issue where refreshing a package results in the change in the object completely.
  • Issue #5074 - Fix an issue where select, insert and update scripts on tables throwing an error.
  • Issue #5076 - Ensure Postfix starts in the container, now it runs as non-root by default.
  • Issue #5116 - Fixed an issue where Save Password control disappears after clicking on it while creating a server.

New in pgAdmin 4 4.17 (Jan 9, 2020)

  • Notable changes in this release include:
  • Allow screen-reader to read relationship attributes in nested elements.
  • Ensure all binaries are securely signed and linked with the hardened runtime in the macOS bundle.
  • Added support to view multilevel partitioned tables.
  • Rename some internal environment variables that could conflict with Kubernetes.
  • Fix an issue where operator, access method and operator class is not visible for exclusion constraints.
  • Ensure that constraints, indexes, rules, triggers, and compound triggers should be created on partitions.
  • Fix syntax highlighting in code mirror for backslash and escape constant.
  • Ensure that the user should be able to select/modify tablespace for the partitioned table on v12 and above.
  • Added support for on-demand loading of items in Select2

New in pgAdmin 4 4.15 (Nov 14, 2019)

  • Added Dark(Beta) UI Theme option.
  • Added support for custom theme creation and selection.
  • Added encrypted password in reverse engineered SQL for roles.
  • Support Enable Always and Enable Replica on triggers.
  • Add an option to request confirmation before cancelling/resetting changes on a Properties dialog.
  • Rename the context menu from 'Drop Server' to 'Remove Server'.
  • Fixed issue where Drop and Disconnect connection menu points are too close to each other.
  • Ensure all messages are retained in the Query Tool from long running queries.
  • Ensure compression level is passed to pg_dump when backing up in directory format.
  • Ensure the number of jobs can be specified when backing up in directory format.
  • Download your copy here.

New in pgAdmin 4 4.14 (Nov 14, 2019)

  • Added Copy with headers functionality when copy data from Query Tool/View Data.
  • Implemented the Query Plan Analyser.
  • Include PostgreSQL 12 binaries in the container.
  • Ensure the MAC OSX app should be notarized for Catalina.
  • Optimize Webpack to improve overall performance.
  • Ensure backup a partition table should not backup the whole database.
  • Ensure that 'ENTER' key in the data filter should not run the query.
  • Highlighted the color of closing or opening parenthesis when user select them in CodeMirror.
  • Ensure that pgAdmin should work behind reverse proxy if the inbuilt server is used as it is.
  • Ensure the search path should not be quoted for Database.
  • Ensure the search path should not be quoted for Function, Procedure and Trigger Function.
  • Fix issue where VALID foreign keys show as NOT VALID in the SQL tab for tables.

New in pgAdmin 4 4.13 (Sep 19, 2019)

  • Added Gather Merge, Named Tuple Store Scan and Table Function Scan icon for explain module.
  • Don't wait for the database connection before rendering the Query Tool UI, for improved UX.
  • Allow configuration options to be set from the environment in the container distribution.
  • Ensure editable and read-only columns in Query Tool should be identified by icons and tooltips in the column header.
  • Add an Italian translation.
  • Refactor Dockerfile to avoid needing to run supporting scripts (i.e. 'docker build .' will work) and minimise layers.
  • Ensure Boolean columns should be editable using keyboard keys.
  • Fix error while importing data to a table using Import/Export dialog and providing "Not null columns" option.
  • Fix an issue where oid column should not be pasted when copy/paste row is used on query output containing the oid column.
  • Ensure port and username should not be mandatory when a service is provided.
  • Unescape HTML entities in database names in the Query Tool title bar.
  • Fix PGADMIN_SERVER_JSON_FILE environment variable support in the container.
  • Ensure sequence with negative value should be created.
  • Fix issue where EXEC script doesn't write the complete script for Procedures.

New in pgAdmin 4 4.12 (Aug 22, 2019)

  • Add support of Compound Triggers for EPAS 12+.
  • Add support for planner support functions in PostgreSQL 12+ functions.
  • Add support for generated columns in Postgres 12+.
  • Use the full tab space for CodeMirror instances on dialogues where appropriate.
  • Allow a banner to be displayed on the login and other related pages showing custom text.
  • Allow enhanced cookie protection to be disabled for compatibility with dynamically addressed hosting environments.
  • Add an optimisation to the internal code responsible for searching for treeview nodes.
  • Display the row count in the popup message when counting table rows, not just in the properties list.
  • Add support in query history to show internal queries generated by pgAdmin during save data operations.
  • Update wcDocker to allow the browser's context menu to be used except in tab strips and panel headers.
  • Fix generation of reverse engineered SQL for partition table, partitions were shown as a child of indexes.
  • Update wcDocker to prevent window state loading creating blank dialogues.
  • Ensure the query tool will work with older versions of psycopg2 than we officially support, albeit without updatable resultsets

New in pgAdmin 4 4.11 (Jul 25, 2019)

  • Add support for editing of resultsets in the Query Tool, if the data can be identified as updatable.
  • Add EXPLAIN options for SETTINGS and SUMMARY.
  • Set the mouse cursor appropriately based on the layout lock state.
  • Prevent flickering of large tooltips on the Graphical EXPLAIN canvas.
  • Fix an error while retrieving json data from the table.
  • Fix 'malformed array literal' error when updating a pgAgent job.
  • Fix an error that could be seen when editing column privileges.
  • Fix an error seen when updating a connection string in a pgAgent job step.
  • EXPLAIN options should be Query Tool instance-specific.
  • Allow keyboard navigation of all controls on subnode grids.

New in pgAdmin 4 4.10 (Jul 25, 2019)

  • Allow some objects to be dragged/dropped into the Query Tool to insert their signature into the query text.
  • Allow the path to /pgadmin4/servers.json to be overridden in the container distribution.
  • Ensure the browser close confirmation is only shown when closing a Query Tool which is running in a separate browser tab.
  • Prevent an error that may occur when editing data with an integer primary key.
  • Fix a quoting issue that caused a blank UI to be displayed when running in French.
  • Ensure the version comparision should be correct for windows installer.

New in pgAdmin 4 4.9 (Jun 27, 2019)

  • Visually distinguish simple tables from tables that are inherited and from which other tables are inherited.
  • Add a framework for testing reversed engineered SQL and CRUD API endpoints.
  • Initial support for PostgreSQL 12.
  • Ensure we include the CSRF token when uploading files.
  • Prevent the geometry viewer grabbing key presses when not in focus under Firefox, IE and Edge.
  • Ensure that browser auto-fill doesn't cause Help pages to be opened unexpectedly.
  • Fix an initialisation error when two functions with parameters are debugged in parallel.
  • Remove additional "SETOF" included when generating CREATE scripts for trigger functions.
  • Ensure the correct label is used in panel headers when viewing filtered rows.
  • Fix issue where new column should be created with Default value.
  • Fix keyboard navigation in "inner" tabsets such as the Query Tool and Debugger.

New in pgAdmin 4 4.8 (Jun 27, 2019)

  • Allow the UI layout to be fully locked or to prevent docking changes.
  • Fix the issue of accessing the SQL for Views and Materialized Views. Regression of pluralisation of folder names.
  • Omit the geometry viewer in the Query Tool from layout saving.
  • Improve the performance of explain plan by embedding the images only when downloading it.

New in pgAdmin 4 4.7 (May 30, 2019)

  • Fixed CSRF security vulnerability issue, per Alvin Lindstam.
  • Added Master Password to increase the security of saved passwords.
  • In server mode, update all the saved server credentials when user password is changed.
  • Fix the responsive layout of the main menu bar.
  • Fix file browser path issue which occurs when client is on Windows and server is on Mac/Linux.
  • Clarify wording for the NO INHERIT option on constraints, per Michel Feinstein.
  • Update the UI logo.
  • Relax the permission check on the directory containing the config database, as it may fail in some environments such as OpenShift.
  • Stop using application/x-javascript as a mime type and use the RFC-compliant application/javascript instead.

New in pgAdmin 4 4.6 (May 30, 2019)

  • Depend on psycopg2-binary in the Python wheel, rather than psycopg2.
  • Added support for Default Partition.
  • Ensure that record should be add/edited for root partition table with primary keys.
  • Ensure the treeview shows all sequences except those used to implement IDENTITY columns (which can be edited as part of the column). Show all if Show System Objects is enabled.
  • Prevent duplicate columns being included in reverse engineered SQL for tables.
  • Ensure sanity of the permissions on the storage and session directories and the config database.
  • Ensure that on clicking Delete button should not delete rows immediately from the database server, it should be deleted when Save button will be clicked.

New in pgAdmin 4 4.5 (Apr 10, 2019)

  • Notable changes in this release include:
  • Ensure that pgAdmin4 should work properly with psycopg2 v2.8.
  • Fixed 'Change Password' issue for SCRAM authentication.
  • Ensure that two consecutive SELECT statements should work properly.
  • Relabel the Save button on the datagrid text editor to avoid confusion with the actual Save button that updates the database.

New in pgAdmin 4 4.4 (Apr 4, 2019)

  • Add support for reverse proxied setups with Gunicorn, and document Gunicorn, uWSGI & NGINX configurations
  • Make the Query Tool history persistent across sessions
  • Add support for IDENTITY columns
  • Add an ePub doc build target
  • Update all Python and JavaScript dependencies
  • Update wcDocker to fix the issue where the Scratch Pad grows in size if the results panel is resized
  • Enlarge the grab handles for resizing dialogs
  • Use the user's full email address (not just the username part) as the basis for the storage directory name

New in pgAdmin 4 4.3 (Mar 7, 2019)

  • Notable changes in this release include:
  • Add a "scratch pad" to the Query Tool to hold text snippets whilst editing.
  • Commit and Rollback buttons to the Query Tool.
  • Automatically expand child nodes as well as the selected node on the treeview if there is only one.
  • Include multiple versions of the PG utilties in containers.
  • Update Alpine Linux version in the docker container.
  • Support double-click on Query Tool result grid column resize handles to auto-size to the content.
  • Allow X-FRAME-OPTIONS to be set for security. Default to SAMEORIGIN.
  • Install a script to start pgAdmin (pgadmin4) from the command line when installed from the Python wheel.
  • Close connections gracefully when the user logs out of pgAdmin.

New in pgAdmin 4 4.0 (Jan 15, 2019)

  • Notable changes in this release include:
  • Slick new UI design
  • Allow query plans to be downloaded as an SVG file
  • Allow servers to be pre-loaded into container deployments

New in pgAdmin 4 3.6 (Nov 29, 2018)

  • Add support for dropping multiple objects at once from the collection Properties panel.
  • Add the ability to import and export server definitions from a config database.

New in pgAdmin 4 3.5 (Nov 1, 2018)

  • Notable changes in this release include:
  • Migrate from Bootstrap 3 to Bootstrap 4.
  • Save the treeview state periodically, and restore it automatically when reconnecting.
  • Support to stop the utility processes (Backup/Restore/Maintenance...).

New in pgAdmin 4 3.4 (Oct 4, 2018)

  • Add shortcuts for View Data and the Query tool to the Browser header bar.
  • Add optional data point markers and mouse-over tooltips to display values on graphs.
  • Ensure the runtime can startup properly if there are wide characters in the account/user name on Windows.

New in pgAdmin 4 3.1 (Jun 28, 2018)

  • Notable changes in this release include:
  • Add support for SSH tunneled connections.
  • Various fixes for handling data in SQL_ASCII databases.
  • Add support for LISTEN/NOTIFY in the Query Tool.
  • Function/Procedure support for PostgreSQL 11.
  • Various fixes and enhancements to the Greenplum support.

New in pgAdmin 4 3.0 (Apr 13, 2018)

  • This release of pgAdmin 4 includes over 100 bug fixes and new features. Notable changes in this release include:
  • The desktop runtime now runs as a system tray application and utilises the browser on the system to display pgAdmin. This resolves numerous bugs and issues caused by QtWebKit/QtWebEngine.
  • Data can now be sorted in edit mode in the Query Tool.
  • Keyboard navigation with configurable shortcuts for many operations has been added to allow use of pgAdmin without a mouse.
  • Dashboard tables and charts can be enabled/disabled.
  • Server and database statistics, functions, partitions, external tables and EXPLAIN are now supported on Greenplum.
  • Support for pg_service.conf files has been added.
  • The Docker Container distribution is vastly slimmed down, having move to Alpine Linux with Gunicorn to host the pgAdmin web application.

New in pgAdmin 4 2.1 (Jan 11, 2018)

  • Notable changes in this release include:
  • Support for colouring connections in the treeview and query tool
  • Configurable formatting for CSV and clipboard datasets
  • Editing of table data for tables with OIDs but no primary keys
  • Immediately retrieve default column values when saving new/edited rows in the query tool

New in pgAdmin 4 2.0 (Oct 5, 2017)

  • Notable changes in this release include:
  • PostgreSQL and EDB Advanced Server 10 support
  • An updated icon set and embedded fonts for consistent look and feel on all platforms
  • Significant speed enhancements, particularly at startup time
  • Out-of-the-box ability to run in either server or desktop mode with no additional configuration changes required
  • Support for SSL certificate based authentication
  • Detailed display of server status info on the dashboards, with options to cancel queries and terminate sessions

New in pgAdmin 4 1.6 (Jul 13, 2017)

  • Notable changes in this release include:
  • Significant performance improvements on Windows, massively reducing initial load time and improving UI response for the vast majority of users during testing.
  • Enhancements to the Query Tool enabling the viewing of large query resultsets far more quickly. For example, a simple test query with 96K rows rendered results within 1 second vs. 22 seconds in pgAdmin III during testing!
  • A major rewrite of the Query History tab allows browsing of queries executed in the query tool with full details including the entire query, in a much nicer user interface.
  • The Desktop Runtime now supports detachable tabs, allowing the Query Tool and Debugger to be opened in new tabs and then moved to alternate displays (from 1.5 this was possible in web mode only)
  • The Query Tool's Results Grid has been overhauled with a new, sleek look an feel supporting selection of arbitrary rows, columns or blocks of cells with full copy support and column sizing retention.
  • The Dashboard tab can now be closed if desired, to minimise query traffic resulting from graph updates.

New in pgAdmin 4 1.5 (Jun 7, 2017)

  • This release of pgAdmin 4 includes over 20 bug fixes and improvements.

New in pgAdmin 4 1.4 (Jun 7, 2017)

  • This release of pgAdmin 4 includes over 30 bug fixes and improvements

New in pgAdmin 4 1.3 (Jun 7, 2017)

  • This is the third release of pgAdmin 4, and includes over 30 bug fixes and improvements.

New in pgAdmin 4 1.22.1 (Jul 12, 2016)

  • Don't barf when connecting to Greenplum or Greenplum HAWQ
  • Fix selection of conversion functions in the CREATE CONVERSION dialogue
  • Properly quote type names in the Type dialogue, and ensure range information is displayed for existing types [Akshay Joshi]
  • Fix selection of cast functions in the Cast dialogue

New in pgAdmin 4 1.22.0 (Jan 28, 2016)

  • Resolved an issue related to check options selection in the view properties dialog with the check option.
  • Merged the libssh2 to the latest version.
  • Properly detect serial columns as such when identifiers have been truncated.
  • Fixes an issue related to the column inheritance information properly, when one (or, more) common columns are inherited from multiple tables.
  • Ensure the correct syntax used for moving the objects from one tablespace to another.
  • Ensure the correct line endings are used when copying from the SQL Pane
  • Toolbar icons, and menu items for Commit and Rollback actions.
  • Display the connection details for the current browser object in the status bar
  • Fixed an issue related to different menus enabling in the Query Tool on Ubunutu unity.
  • Reset the position (x, y) for dialog(s), and frame(s) to 0 (if found negative), while saving its position and size.
  • Fixes an issue identifying the return type to TABLE in some cases, using pg_get_function_result(..) for the same instead of format_type(..)
  • Honour PGPASSFILE environment variable for saving, retrieving the password instead of always works with pgpass.conf (on windows)/.pgpass (on non-windows)
  • Fix a segfault occurs while detecting transaction section requirement, when autocommit has been disabled.
  • Format execution time in a more readable manner
  • Improve sorting in Data editor
  • Allow to format the selecte SQL using external tools in Query Editor
  • Allow to set auto-commit mode to on/off in the query editor
  • Set the focus on browser tree windows on startup
  • Make the arrow key navigation consistent across all platform on the object browser tree
  • Show indexes for the materialized views in Query pane
  • Add support for searching materialized views in the "Search Objects" dialog

New in pgAdmin 4 1.20.1 (Jan 28, 2016)

  • Resolved an assertion error during opening the popup menu for plugins on wxWidgets 3.0
  • Do not try unlock the mutex, which was not owned by the thread, while creating the popup menu

New in pgAdmin 4 1.20.0 (Feb 20, 2015)

  • Resolving the inconsistency of preservation of modified information of the columns, while adding/editing a table from the table dialog
  • Add missing nodes to graphical explain plan
  • Fix the Resource Groups dialog - separated the statements, which can not be ran in single transaction
  • Support for Slony-I 2.2+ with PostgreSQL 9.3+
  • Support smallserial columns in Edit Data Window
  • Restore the user specified size on the grid (which contains the result) in Query windows to fix an issue related to the column size is too narrow on subsequent Explain execution
  • Empty the Undo/Redo history everytime new file is opened
  • Added accelerator F8 for 'Execute to file' in the Query window
  • Beautify the query shown in the SQL pane for the functions having multiple arguments by adding new lines with small modification by me
  • Check for the columnlist for the UPDATE OF syntax on trigger also works with PPAS 9.5+
  • Proper saving of columns width in the server status window
  • Fix support for triggers with inline code on PPAS
  • CHECK OPTION is applicable to the views only, and not the materialized views
  • Prevent a crash during the update of the macro or favourite list
  • Allow quick injectection of favourites by name
  • Fix handling of saving macros after pasting a query in the box
  • Fix handling of char()[] columns in the Edit Grid
  • Support the new check_option parameter of views
  • Handle the 9.4 MOVE clause of ALTER TABLESPACE
  • Add a new action menu to refresh a materialized view
  • Support the new 9.4 columns in pg_stat_activity
  • Save search options for next time
  • Ensure Favourite queries are only saved when the OK button is pressed
  • Fix an issue refreshing functions in PPAS packages
  • Improve handling of lost connections
  • Allow searching for database objects by comment and definition content
  • Add support for Resource Groups in PPAS 9.4
  • Add Save and Exit shortcut keys to the edit grid
  • Enable backward search in SQL Box using Shift + F3

New in pgAdmin 4 1.18.2 (Feb 20, 2015)

  • Don't set log_min_messages from the debugger
  • Fix a crash on OSX when run explain through shortcut in query editor, when mouse is over a existing shape, and popup, showing the step information, is on.
  • Using the GetOid() function instead of GetLong() for Oid columns [Ian Barwick]

New in pgAdmin 4 1.18.1 (Nov 12, 2013)

  • Allow the dump of pg schemas
  • Prevent a crash on Windows when dropping a column or a constraint on a table
  • Ensure DDLScript will work with Slony 2.2+ which has a new SQL level API
  • Fix ordering of object types in the display options and add Event Triggers which were missing
  • Ensure the debugger can cope with functions that have an OUT parameter as the first
  • Fix the quoting of user mapping objects
  • Ensure that materialised views are available as targets
  • for synonyms
  • Fix the query used to find tables in a Slony replication set
  • Prevent a crash if a user starts an external process such as a backup, and then immediately hits cancel
  • Fix a memory leak in the Event Trigger code

New in pgAdmin 4 1.18.0 (Sep 12, 2013)

  • Fix a layout bug in the graphical explain renderer that could render nodes on top of each other.
  • Fix Slony's DDL Script support
  • Add support for Event Triggers in 9.3+
  • Avoid using a Help cache file that needs to be world writeable, and ensure sed is happy when post-processing helpfiles.
  • Fix the help path on the import dialogue and improve the error handling
  • Fix path the the Search Objects help doc
  • Fix UTF-8 display for guru hints
  • Prevent a crash when creating a stored procedure in PPAS
  • Disable the Favourites menu items if there is no favourites file path
  • Make No the default button on the Truncate confirmation dialog
  • Support Materialized
  • Fix comments on constraints
  • Fix schema prefixes in cast definitions in the browser.
  • Treat sequences as first class objects in the Grant Wizard. Support USAGE and remove obsolete RULE permissions
  • Set the default backup type to "Custom".
  • Improve the copy handling on the Edit Grid so that it works more consistently and predictably.
  • Fix comments on columns.
  • Remove the "Apply" buttons from the function, view package and external table dialogues. Their use is discouraged, and the code is fragile, complex and very buggy.
  • Fix a crash that could occur if the browser fails to detect that an object has been changed by another session.
  • Change the default SQL box font to a slightly smaller size on GTK based platforms.
  • Don't prompt the user for a password if they're using a client certificate.
  • Ensure global backups use the maintenance database to avoid access issue with postgres or template1.
  • Fix SSL certificate authentication.
  • Fix renaming and schema changes for stored procedures in PPAS
  • Add SSH tunnelling support to allow connections to be made to hosts via an SSH server
  • Display the index validity in the properties list for indexes and index-based constraints
  • Add an option to include column headers when copying from the query tool results
  • Allow the decimal mark displayed by the query tool to be configured as the thousands separator can
  • Ensure the Query Tool's maximum column length setting is honoured.
  • Handle default privileges to PUBLIC correctly.
  • Add tab option in the Import dialog.
  • Add smallserial handling.
  • Fix the editing of pg_hba.conf files
  • Fix the display of extension owner names.
  • Add a title to the backup and restore windows.
  • Fix a bug that could cause a NOTICE to be displayed when rendering FTS Configurations in the tree.
  • Don't try to display dependents or dependencies for pgAgent jobs, schedules or steps.
  • Fix the handling of expiry times when modifying roles.
  • Prevent foreign keys being recreated unnecessarily when modifying tables
  • Fix handling of Greenplum partitions
  • Add -V/--version CLI option.
  • Add actions menu to the serverstatus tool.
  • Fix the database SQL when reseting a configuration parameter.
  • Refresh the toolbar buttons when a list has been updated.
  • Fix the "NO INHERIT" query.
  • Display default privs.
  • Sort references by schema name and relation name in dlgForeignKey.
  • Fix the change of the superuser attribute.
  • Fix the queries used to get object comments to allow for duplicate OIDs that may be present following use of pg_upgrade.

New in pgAdmin 4 1.16.1 (Feb 15, 2013)

  • Prevent a crash that could happen if further changes were made on a dialogue after using the Apply button.
  • Save new comments on already existing columns when editing a table.
  • Fix the query editor behavior when executing COPY TO stdout and COPY FROM stdin
  • Date picker controls returns a full timestamp by default, which can cause inadvertent date changes on jobs and role validity dates. Ignore the time part.
  • Fix query for database descriptions
  • Avoid querying the catalogs for toast table settings for every table in the database. This gives a huge performance gain with large schemas.
  • Prevent a crash when refreshing a node which has a child with an open dialogue
  • Fix dropping/renaming of indexes
  • Avoid updating the GQB model on every key press in the query tool
  • Fix a crash that can occur when renaming objects.
  • Fix dropping of constraints
  • Fix the "blocked by" column in the server status dialogue on 9.2 servers
  • Prevent a crash if the query tool is closed whilst a file is loading
  • Fix setting of comments on PPAS procedures.
  • Don't autosize the search results columns if no results are found
  • Prevent a crash if opening a second config file in the editor.
  • Prevent the SSL options combo box displaying duplicate options if the server dialogue is reopened
  • Fix trigger query when connected to PostgreSQL 8.2 or lower
  • Fix message when executing an empty query