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](https://www.pgadmin.org/docs/pgadmin4/9.5/release_notes_9_5.html). pgAdmin is the leading open-source graphical management tool for PostgreSQL. For more information, please see [the website](https://www.pgadmin.org/).
###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](https://www.pgadmin.org/download/).
