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](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 [the website](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 the [tarball
area](https://www.pgadmin.org/download/).
