The pgAdmin Development Team has announced the release of pgAdmin 4 version 9.5, which incorporates 18 bug fixes and introduces new features. Significant updates encompass the introduction of a new permission to disable the "Change Password" feature for a pgAdmin role, implementation of role-based restrictions for editing server connections, enhancements for customizing keyboard shortcuts, the addition of a search box, and the capability to preserve workspace, query windows, and pgAdmin state during shutdowns or restarts. The update enhances PL/pgSQL code folding capabilities and introduces support for nested blocks. The release additionally resolves concerns related to SQL syntax highlighting, query tool functionality, and user interface layout. The release of the Python package to PyPi has encountered a delay.
pgAdmin 4 v9.5
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.
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 gunicorn process within Docker.
Bugs/Housekeeping:
- Improved PL/pgSQL code folding and support 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.
Download your copy now!
