pgAdmin 4 v6.9 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.9. This release of pgAdmin 4 includes 29 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.

Notable changes in this release include:

Features:

• Port query tool to React.

  This feature is a major revamp to the query tool in terms of the GUI. Some other related features have also been added to this. Some major enhancements are adding a status bar, toolbar buttons shown on the respective panels, fixing the headers of the slick grid, and many more.

• Added options 'Ignore owner' and 'Ignore whitespace' to the schema diff panel.

  This feature introduces the ‘ignore owner’ and ‘ignore whitespace’ options on the schema diff panel itself to provide the ease to the users to change the setting and compare the databases or schemas.

• Added capability to deploy PostgreSQL servers on EDB BigAnimal.

  This feature allows the users to deploy the PostgreSQL and EDB Advanced Server on the EDB BigAnimal Cloud.

• Added status bar to the Query Tool.

• Ensure that row numbers should be visible in view when scrolling horizontally.
• Relocate GIS Viewer Button to the Left Side of the Results Table.
• Added support for Azure AD OAUTH2 authentication.

Bugs/Housekeeping:

• Only set permissions on the storage directory upon creation.
• Improvement to the Geometry Viewer popup to change the size of the result tables when column names are quite long.
• Fixed an issue where the downloaded ERD diagram was 0 bytes.
• Don't strip binaries when packaging them in the server RPM as this might break cpython modules.
• Ensure that Columns should always be visible in the import/export dialog.
• Fixed an issue where the copy and paste row does not work if the first column contains no data.
• Fixed an issue where the Browser panel is not completely viewable.
• Fixed sorting issue in the statistics panel.
• Ensure that sorting should be preserved on refresh for Server Activity.
• Fixed an issue where the drag and drop table in ERD throws an error.

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.