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](https://www.pgadmin.org/docs/pgadmin4/8.9/release_notes_8_9.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: * 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](https://www.pgadmin.org/download/).
