pgAdmin 4 v9.12 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.12. This release of pgAdmin 4 includes 3 new features and 21 bug fixes/housekeeping changes. 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:

• Add new options like INHERIT and SET to the Role's membership tab.
• Add a new button in the query tool data output toolbar to get entire range of data.
• Enhance OAUTH2 and OIDC authentication support with improved claims handling and configuration options.

Bugs/Housekeeping:

• Mask the secret key for restrict option in the process watcher when restoring plain SQL file (CVE-2026-1707).
• Fix Query Tool state restoration for new connections and queries.
• Fix pg_restore logs to distinguish UI sync issues from actual failures.
• Optimize checkbox selection logic in backup dialog objects tree.
• Fixed an issue where double click to open a file in the file manager is not working.
• Ensure saved shared server passwords are re-encrypted on password change.
• Fixed an issue where the dashboard freezes on initial render when there is a high number of locks.
• Fixed the SSL certificate issue while checking for the upgrade.
• Fixed a sorting issue in the system stats memory usage table.
• Disable Parameters and Membership fields when object is not new for Login and group roles.
• Fixed an issue where the Query History panel would auto-scroll to the top and did not preserve the scroll bar position for the selected entry.
• Fixed an issue where pgAdmin4 app on macOS cannot auto-update while running on a read-only volume even if present in the Applications folder.
• Fixed an issue where connection parameters were using localized values instead of literal values, causing connection failures.
• Ensure the container deployment supports boolean values in yaml format.
• Fix pgAdmin fails when performing Backup/Restore on a PostgreSQL connection defined exclusively via pg_service.conf.

Builds for Windows and macOS are available now, along with a Python Wheel, Docker Container, RPM, DEB Package, and source code tarball from the download area.