The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.5. This release of pgAdmin 4 includes 18 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.

Note: The publication of the Python package to PyPi has been delayed and will be completed as soon as possible.

Notable changes in this release include:

Features:

• Add a new permission to allow disabling the "Change Password" feature for a pgAdmin role.
• Added role-based restrictions for editing server connections.
• Added support for customizing keyboard shortcuts in the Query Tool's Edit menu.
• Add a search box to enable searching within the preferences tab.
• Added support to preserve the workspace, query windows, and pgAdmin state during an abrupt shutdown or restart.
• Open preferences in a new tab instead of a dialog for a better user experience.
• Supports JSON logging for the gunicorn process within Docker.

Bugs/Housekeeping:

• Improved PL/pgSQL code folding and support for nested blocks.
• Add a flag to allow access to system Python packages on recent Linux distributions.
• Fixed an issue where utilities such as pg_dump and pg_restore failed to log error messages when required dependency files were missing.
• Fixed an issue where the Schema Diff Tool incorrectly reported differences due to variations in the order of the privileges.
• Fixed an issue in SQL syntax highlighting where the same color was used for both variable names and datatypes.
• Fixed an issue in the query tool where using multiple cursors to copy text resulted in only the first line being copied.
• Fixed an issue where data export using a query opened the wrong dialog type.
• Fixed an issue where data export using a query failed when the query contained a newline character.
• Fixed a UI layout issue that occurred after upgrading from pgAdmin v9.2 when all tabs had been closed prior to the upgrade.
• Fixed an issue where the Columns node was not visible under Catalog Objects.

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.