Version 7.8

Release date: 2023-10-19

This release contains a number of bug fixes and new features since the release of pgAdmin 4 v7.7.

Supported Database Servers

PostgreSQL: 12, 13, 14, 15, and 16

EDB Advanced Server: 12, 13, 14 and 15

Bundled PostgreSQL Utilities

psql, pg_dump, pg_dumpall, pg_restore: 16.0

New features

Issue #640 - Add support for foreign table’s new functionality for PG 11 and above.

Issue #6373 - Add ‘GENERATED ALWAYS AS..’ option while creating column constraints for Foreign Table.

Issue #6797 - GUI representation of the system’s activity using the ‘system_stats’ extension.

Issue #6802 - Added ‘load_balance_hosts’ connection string parameter for PG 16 and above.

Housekeeping

Issue #6782 - Use PG16 as the default PostgreSQL version.

Bug fixes

Issue #4995 - Fixed an issue in ERD tool where the downloaded images have a few links cut.

Issue #6482 - Fixed an issue where the wrong message “Current database has been moved or renamed” is displayed when debugging any function.

Issue #6674 - Fix an issue where foreign table column name becomes “none” if the user changes any column data type.

Issue #6718 - Pin the cryptography version to fix PyO3 modules initialisation error.

Issue #6790 - Ensure that the backup works properly for PG 16 on the latest docker image.

Issue #6799 - Fixed an issue where the user is unable to select objects on the backup dialog due to tree flickering.