The graphical PostgreSQL management tool pgAdmin 4 has been updated. The updated version includes 18 bug fixes and new features.

pgAdmin 4 v6.20 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.20. This release of pgAdmin 4 includes 18 bug fixes and new features. For more details please see the  release notes.

pgAdmin is the leading Open Source graphical management tool for PostgreSQL. For more information, please see  the website.

Note

Whilst pgAdmin 4 does not formally support downgrading, it typically does work if you uninstall and then reinstall the application.

This release of pgAdmin includes a major change to the configuration database structure which is NOT backward compatible, and therefore a straightforward downgrade will not work.

If you are using the default SQLite database for your configuration (as will be the case for the vast majority of users), the old version of the configuration database will be backed up to "pgadmin4.db.prev.bak" in your storage directory. If you wish to downgrade to pgAdmin v6.19 or earlier, after running v6.20, you must restore this file to "pgadmin4.db" in the same directory, BEFORE starting the older version of pgAdmin again.

If you are storing your configuration in an external PostgreSQL database, you will need to restore a backup of that database taken prior to the upgrade to v6.20, if you wish to return to the earlier version.

Changes made after migration such as the addition of new servers, will not be stored in the old database and will have to be re-created following a downgrade.

Notable changes in this release include:

Features:

• Added support for setting PostgreSQL connection parameters.

  With the help of this feature, a user can specify the connection parameters when connecting to a server using the server dialog. In the server dialog, we have added a new Parameters tab and removed the SSL tab. The Parameters tab now contains all SSL tab controls.

Bugs/Housekeeping:

• Use uplot for Dashboard graphs to reduce CPU usage.
• Fixed an issue where the client cert location was not stored on the shared servers.
• Fix orphan database connections resulting in an inability to connect to databases.
• Ensure that the system columns should not visible in the import/export data.
• Increase the length of the value column of the setting table.
• Fix an issue where drag and drop object names are not working.
• Fix an issue where the role is used as a username for newly added servers when opening the query tool.
• Fixed an issue where Query history is not getting loaded with the external database.
• Fix failing import servers CLI due to vulnerability fix.

Builds for Windows and macOS are available now, along with a Python Wheel, Docker Container, RPM, DEB Package, and source code tarball from the  tarball area.

pgAdmin 4 v6.20 Released