The pgAdmin Development Team has released pgAdmin 4, version 8.12, which includes 13 bug fixes and new features. Notable improvements include restoring preferences to their default values, creating a new configuration variable for special email domains, and allowing non-continuous selected SQL code chunks in the query tool.
The release also tackles security vulnerabilities, increases the flexibility of SchemaView and DataGridView, and resolves server disconnection issues. The update also adds support for OIDC-based OAuth2 authentication, resolves cursor movement issues, and improves confirmation modals.
pgAdmin 4 v8.12 Released
The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.12. This release of pgAdmin 4 includes 13 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 feature to restore preferences to their default values.
- Add a new config variable - ALLOW_SPECIAL_EMAIL_DOMAINS to allow special domains for pgAdmin user emails.
- Allow running non-continuous selected SQL code blocks in the query tool.
Bugs/Housekeeping:
- Fixed a security issue where the OAuth2 client ID and secret were exposed through the web browser (CVE-2024-9014).
- Improved the extensibility of the SchemaView and DataGridView.
- Fix the query tool restore connection issue on the server disconnection from the left side object explorer.
- Revamp the current password saving implementation to a keyring and reduce repeated OS user password prompts.
- Fixed an issue where users could not use pgAdmin if they did not have access to the management database.
- Fixed an issue where servers listed in the servers.json file were being reimported upon container restart.
- Added support for OIDC based OAuth2 authentication.
- Fixed an issue where the cursor moves to the end of line when editing input fields.
- Fixed an issue where different client backend shows all SQL are the same.
- Fixed an issue where the "Quit App" confirmation modal in desktop app is not respecting "Confirm on close or refresh?"
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.