pgAdmin 4 v7.8 Released

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

• GUI representation of the system's activity using the 'system_stats' extension.

  This feature is used to see the GUI representation of the system's activity using the 'system_stats' extension. Added a new tab 'System Statistics' under the Dashboard tab. This new tab contains the details about CPU, Memory, and Storage.

• Add support for foreign table's new functionality for PG 11 and above.

• Allow setting custom username for shared servers, with default as username of server being shared.
• Add 'GENERATED ALWAYS AS..' option while creating column constraints for Foreign Table.
• Added 'load_balance_hosts' connection string parameter for PG 16 and above.

Bugs/Housekeeping:

• Fixed an issue in ERD tool where the downloaded images have a few links cut.
• Fixed an issue where user was not able to assign new/old columns as primary key once column with primary key is deleted.
• Add support for setting prepare threshold in server connection.
• Fix an issue where global/native keyboard shortcuts are not working when any cell of data output grid has focus.
• Fixed query history slowness issue by storing query only for those having certain threshold max length.
• Ensure that the backup works properly for PG 16 on the latest docker image.
• Fixed an issue where non-super PostgreSQL users are not able to terminate their own connections from dashboard.
• Fix an issue where scale in columns is not allowed to have value as 0 or below.
• 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.
• Fix an issue where user login is not working if username/email contains single quote in server mode.

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.