The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.9. This release of pgAdmin 4 includes 20 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:

• Provide the option to set a theme based on OS theme preference.

Bugs/Housekeeping:

• Remove the usage of MUI makeStyles as it doesn't support React 18.
• Fix the permissions issue in the pgAdmin installation directory on Debian and RHEL-8 platforms (CVE-2024-6238).
• Fixed an issue where resizable data editors in the query tool should not be allowed to resize beyond the app window bounds.
• Ensure that a user can connect to a server using SSL certificates and identity files from a shared storage.
• Fixed an issue where the dark theme shows a white background when all tabs are closed.
• Fixed an issue where the schema diff incorrectly marked tables as different due to schema-qualified trigger functions in the trigger definitions.
• Fixed an issue where backslash breaks syntax highlighting.
• Fixed an issue where query tool shortcuts for find/replace are not working.
• Fixed new line indentation in the query editor and added a user preference to disable it.
• Fixed migration failure while using an external database.

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.