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

• Added the new columns "last_seq_scan" and "last_idx_scan" from the pg_stat_all_tables and pg_stat_all_indexes tables respectively to the Statistics tab.
• Added support for excluding multiple tables while taking Backup.

Bugs/Housekeeping:

• Fixed an XSS vulnerability in the /settings/store endpoint (CVE-2024-4216).
• Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215).
• Update UI library MUI from v4 to v5.
• Upgraded Flask, Flask-Security-Too, Werkzeug, and other dependencies, ensuring compatibility with Python 3.7.
• Fixed violates check constraint issue when creating a pgAgent schedule.
• Fixed an issue where pressing backspace should remove the spaces and not the entire tab width, on enabling 'Use spaces?' in the preferences.
• Fixed an issue where incorrect select/exec scripts were generated for functions/procedures.
• Fixed an issue when closing the view data second tab; it raises the error that the 'ViewCommand' object has no attribute 'auto_commit'.
• Install dbus-python, an in-direct dependency of the Keyring package as a system package for Debian platforms.

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.