pgAdmin 4

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.13. This release of pgAdmin 4 includes 25 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Replace ... [More] infinite scrolling with pagination in query tool data output for better UX and performance. Add an object menu option to disconnect all server and database connections. Alternate the background color of rows to enhance readability. Allow to pass PGADMIN_CONFIG_CONFIG_DATABASE_URI from docker secrets. Format dashboard graph metrics for better readability. Added support for auto-detecting and setting the End-of-line character (LF/CRLF) in the query tool editor. Make the background color for the serial number and header cells distinct. Bugs/Housekeeping: Updated the react-menu library from v2 to v4. Fixed an issue that allowed the Enter key to save data in the result grid text editor. Move 'About pgAdmin 4' to the app menu on macOS. Fixed an issue where the query tool was crashing when an empty geometry was being rendered. Fixed an issue where the Dashboard tab showed 'Something went wrong'. Fixed an issue where cursor selection is not visible in the PSQL tool. Allow OAuth2 params OAUTH2_NAME, OAUTH2_DISPLAY_NAME, OAUTH2_ICON, OAUTH2_BUTTON_COLOR to be optional. Add appropriate minimum width and height settings for desktop apps to avoid apps accidentally going below visibility levels. Fixed an issue where the graphical explain kept the node details open even after the plan changed. Fixed an issue in the debugger where the character data type function arguments were being truncated. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.12. This release of pgAdmin 4 includes 13 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Added ... [More] feature to restore preferences to their default values. Add a new config variable - ALLOW_SPECIAL_EMAIL_DOMAINS to allow special domains for pgAdmin user emails. Allow running non-continuous selected SQL code blocks in the query tool. Bugs/Housekeeping: Fixed a security issue where the OAuth2 client ID and secret were exposed through the web browser (CVE-2024-9014). Improved the extensibility of the SchemaView and DataGridView. Fix the query tool restore connection issue on the server disconnection from the left side object explorer. Revamp the current password saving implementation to a keyring and reduce repeated OS user password prompts. Fixed an issue where users could not use pgAdmin if they did not have access to the management database. Fixed an issue where servers listed in the servers.json file were being reimported upon container restart. Added support for OIDC based OAuth2 authentication. Fixed an issue where the cursor moves to the end of the line when editing input fields. Fixed an issue where different client backend shows all SQL are same. Fixed an issue where "Quit App" confirmation modal in desktop app is not respecting "Confirm on close or refresh?" Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.11. This release of pgAdmin 4 includes 15 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Add a ... [More] home button to the geometry viewer to set the original zoom level when the viewer is opened. Bugs/Housekeeping: Fixed an issue where refreshing the Schema Diff tool opened in a new tab caused an error. Fix server heartbeat logging error after deleting the server. Fixed an issue where the Generate Script ignored filter conditions when a parent node was selected. Fixed an issue where delete object(shortcut key) affected both text and Object Explorer items. Fix an issue where the ERD tool should be able to open saved pgerd file when using keyboard shortcuts. Fixed an issue where the REVOKE statement in the create script was throwing an error if the role contained special characters. Improve code highlighting in the query editor. Fix an issue where the wheel package is not getting installed on the arm64-based macOS version < 14. Fixed an issue where column resizing is not working in the search objects dialog Fixed an issue where the value in the find box is not updating with selected text in the editor if the find is already open and re-triggered. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.10. This release of pgAdmin 4 includes 29 bug fixes and new features. For more details please see the release notes. Note: With this release, pgAdmin 4 has transitioned from ... [More] NW.js to Electron Notable changes in this release include: Features: Add support for Postgres Server Logs for Text, CSV, and JSON format in plain and tabular formats. Add support for highlighting selection matches in the query editor. Add a keyboard shortcut to close the active tab panel. Bugs/Housekeeping: Replace pgAdmin NW.js container with Electron container. Ensure that pgAdmin 4 is compatible with PostgreSQL v17. Fixed an issue where paste operation in query tool data grid should skip bytea columns and put the value as NULL instead. Ensure pgAdmin never makes network requests to Google etc. Fixed the permission denied issue for functions of the pgstattuple extension when accessing statistics with a non-admin user. Updated entrypoint.sh to utilize the email-validator package for email validation. Fixed an issue where users could not insert characters at the desired location, as it was added to the end of the line. Fixed an issue where users could not autofill their saved passwords in the connect server dialog in the browser. Fixed an issue where boolean values in node details of the graphical explain plan were not interpreted correctly. Ensure that pgAdmin works when opened in an iframe. Download your copy now! [Read News] [Less]

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. Notable changes in this release include: Features: Provide ... [More] 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. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.8. This release of pgAdmin 4 includes 5 bug fixes. For more details please see the release notes. Notable changes in this release include: Bugs/Housekeeping: Fix an issue where ... [More] user authentication fails with special characters in the password. Fixed an issue where canceling a query without privilege does not display any message on the query tool. Fix the issue where docker with SSL v8.7 fails to start. Fixed an issue where the size displayed as 'NaN B' for all databases in the statistics tab. Fixed an issue where backup and restore operations failed with the error 'This build does not support compression with gzip'. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.7. This release of pgAdmin 4 includes 19 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Added ... [More] support for the 'Add to macros' feature and fixed various usability issues. Added support for executing the query at the cursor position in the query tool. Changes in Query Tool, Debugger, and ERD Tool shortcuts to remove the use of Accesskey which will allow them to be customized. Added support for viewing PGD Clusters. Enhance the Delete dialog by highlighting the names of the objects to be deleted in bold. Added support for platform Ubuntu 24.04 and Fedora 40. Bugs/Housekeeping: Upgrade react-table from v7 to v8. Ensure that Schema Diff does not indicate a table as different when the trigger names are the same but the trigger function body is different. Fixed an issue of the pgAdmin window size increasing each time it was reopened. Update the documentation for preferences dialog and keyboard shortcuts. Fixed an issue where pgAdmin fails to start when Ubuntu OS is upgraded to a major version. Fixed incorrect highlighting for C-Style escape strings in SQL editor. Fixed an issue where the recover password button was enabled even when no email was provided. Fixed an issue where resetting the password from the password reset link was not working. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.6. This release of pgAdmin 4 includes 15 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Added the ... [More] new columns "last_seq_scan" and "last_idx_scan" from the pg_stat_all_tables and pg_stat_all_indexes tables respectively to the Statistics tab. Added support for excluding multiple tables while taking Backup. Bugs/Housekeeping: Fixed an XSS vulnerability in the /settings/store endpoint (CVE-2024-4216). Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215). Update UI library MUI from v4 to v5. Upgraded Flask, Flask-Security-Too, Werkzeug, and other dependencies, ensuring compatibility with Python 3.7. Fixed violates check constraint issue when creating a pgAgent schedule. Fixed an issue where pressing backspace should remove the spaces and not the entire tab width, on enabling 'Use spaces?' in the preferences. Fixed an issue where incorrect select/exec scripts were generated for functions/procedures. Fixed an issue when closing the view data second tab; it raises the error that the 'ViewCommand' object has no attribute 'auto_commit'. Install dbus-python, an in-direct dependency of the Keyring package as a system package for Debian platforms. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.5. This release of pgAdmin 4 includes 24 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Added ... [More] support for EDB Job Scheduler. Added support for viewing Log Based Clusters. Added support for UNIX socket in entrypoint.sh for Docker implementation. Added support for provider, deterministic, version, and RULES parameters while creating collation. Bugs/Housekeeping: Fixed a remote code execution issue in the validate binary path (CVE-2024-3116). Fixed an issue in Schema Diff where Columns with sequences get altered unnecessarily. Fixed schema diff wrong query generation for the table, foreign table, and sequence. Fixed an issue where the maximize icon is missing from the query tool panel. Fix an issue in editor where Format SQL shortcut and multiline selection are not working. Fix an issue in the editor where the "Use Spaces?" preference of the Editor is not working. Fixed an issue where Triggers, Rules, and Indexes were absent from the Schema Diff when comparing views. Fixed an issue where taking a backup of a shared server was using the server owner's user name. Fix an issue in the query tool where custom keyboard shortcuts are not working for some. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.4. This release of pgAdmin 4 includes 16 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Allow ... [More] preferences customization using a configuration file. Add support for JSON log format. Add --yes option for skipping the confirmation prompt while deleting the user via CLI for scripting purposes. Bugs/Housekeeping: Unsafe Deserialization and Remote Code Execution by an Authenticated user in pgAdmin 4 (CVE-2024-2044). Upgrade CodeMirror from version 5 to 6. Fix multiple issues where PasswordExecCommand was not working in server mode and PasswordExecCommand was not loaded when importing servers. Fix the tabbed panel backward/forward shortcut for tabs. Fixed an issue where dependencies and dependents were not showing if a composite type was used as an attribute in another composite type. Remove role-related checks on the UI dashboard when terminating a session/query and let PostgreSQL take care of it. Fix an issue where the scripts created by generating script of Schema diff for Table with sequence was not working earlier. Added documentation for Dashboard's System Statistics tab. Ensure that the OAuth2 session is logged out when users log out from pgAdmin. Download your copy now! [Read News] [Less]