The pgAdmin Development Team are pleased to announce pgAdmin 4 version 5.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.

Notable changes in this release include:

Features:

• Highlighted long running queries on the dashboards

  This feature is implemented to highlight the long running queries. It allows the user to provide the warning and alert threshold values in minutes. Depending on the threshold value pgAdmin4 highlights the long running queries on the Dashboard.

• Added support for Reassign/Drop Owned for login roles

  This feature allows the user to change the ownership of database objects owned by a database role or remove database objects owned by a database role.

• Added support for OAuth 2 authentication

  This feature allows the user to connect to the pgAdmin 4 server using OAuth2 authentication. To enable OAUTH2 authentication for pgAdmin, you must configure the OAUTH2 settings in the config_local.py or config_system.py file.

• Added option to provide maximum width of the column when 'Resize by data?’ option in the preferences is set to True

• Do not block the query editor window when running a query

Bugs/Housekeeping:

• Ensure that the Data Output panel can be snapped back after it is detached.
• Fixed replace keyboard shortcut issue in the query tool on the normal keyboard layout.
• Remove leading whitespace and replace it with '[...] ' in the Query Tool data grid so cells don't look empty.
• Fixed an issue in the search object when searching in 'all types' or 'subscription' if the user doesn't have access to the subscription.
• Fixed an issue where the New Connection Drop Down had lost the default maintenance database, auto-select, and tab-through functionality.
• Ensure that setting 'Open in new browser tab' should be visible, it should not be based on the value of 'ENABLE_PSQL'.
• Disable the email deliverability check that was introduced in flask-security-too by default to maintain backwards compatibility.
• Fixed an issue where incorrect column names were listed in the properties of Index.

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.