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