Version 9.5¶

Supported Database Servers¶

PostgreSQL: 13, 14, 15, 16 and 17

EDB Advanced Server: 13, 14, 15, 16 and 17

Bundled PostgreSQL Utilities¶

psql, pg_dump, pg_dumpall, pg_restore: 17.2

New features¶

Issue #1926 - Add a new permission to allow disabling “Change Password” feature for a pgAdmin role.

Issue #1947 - Added role-based restrictions for editing server connections.

Issue #2659 - Added support for customizing keyboard shortcuts in the Query Tool’s Edit menu.

Issue #2864 - Add a search box to enable searching within the preferences tab.

Issue #3319 - Added support to preserve the workspace, query windows, and pgAdmin state during an abrupt shutdown or restart.

Issue #6743 - Open preferences in a new tab instead of a dialog for better user experience.

Issue #8665 - Supports JSON logging for gunicorn process within Docker.

Housekeeping¶

Bug fixes¶

Issue #6118 - Improved PL/pgSQL code folding and support nested blocks.

Issue #7173 - Add a flag to allow access to system Python packages on recent Linux distributions.

Issue #7466 - Fixed an issue where utilities such as pg_dump and pg_restore failed to log error messages when required dependency files were missing.

Issue #8032 - Fixed an issue where the Schema Diff Tool incorrectly reported differences due to variations in the order of the privileges.

Issue #8235 - Fixed an issue in SQL syntax highlighting where the same color was used for both variable names and datatypes.

Issue #8691 - Fixed an issue in the query tool where using multiple cursors to copy text resulted in only the first line being copied.

Issue #8803 - Ensure that Keyboard shortcuts for save and download actions should not called when their respective UI buttons are disabled.

Issue #8808 - Fixed an issue where data export using a query opened the wrong dialog type.

Issue #8809 - Fixed an issue where data export using a query failed when the query contained a newline character.

Issue #8830 - Fixed a UI layout issue that occurred after upgrading from pgAdmin v9.2 when all tabs had been closed prior to the upgrade.

Issue #8834 - Fixed an issue where the Columns node was not visible under Catalog Objects.