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 at:

https://www.pgadmin.org/docs/pgadmin4/7.8/release_notes_7_8.html

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

https://www.pgadmin.org/

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:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project