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.