pgAdmin 4

The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.7. This release of pgAdmin 4 includes 22 bug fixes and new features. For more details, please see the release notes. Notable changes in this release include: ... [More] Features: Add support for automatic updates in the pgAdmin 4 Desktop application on macOS. Added GENERIC_PLAN, MEMORY, and SERIALIZE options to EXPLAIN/EXPLAIN ANALYZE command. Add support for changing the cursor blink rate within the editors. Add support for server tag-based filtering in the Object Explorer. Added support for builtin locale provider while creating Collation. Bugs/Housekeeping: Introduced an ‘Editor’ preferences category and migrated all editor related settings into it. Fixed an issue where CPU usage was very high on Windows when opening the psql tool. Fixed an issue where adding breakpoints caused errors, and stepping out of a nested function removed breakpoints from the parent function. Fixed an issue where custom column widths in the result grid of Query Tool or View/Edit Data were reset after re-executing a query. Fixed the issue where updating the name of a table column does not reflect in the corresponding primary key constraint. Make Dashboard tables to be vertically resizable. Fixed the incorrect behaviour of the option deduplicate items after creating the index. Added PKEY index in the index statistics summary. Fixed an issue where downloading images on the ERD tool was not working in desktop mode. Ensure the scratch pad in the Query Tool is not restored after it is closed. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.6. This release of pgAdmin 4 includes 4 new features and 7 bug fixes/housekeeping changes. For more details, please see the release notes. Notable changes in this release ... [More] include: Features: Ensure that keyboard shortcuts are displayed in tooltips, context menus, and the main menu. Implemented a server-side cursor to enhance performance when retrieving large datasets. Added support for setting a custom SESSION_DIGEST_METHOD in pgAdmin 4 to facilitate FIPS compliance. Enable the PKCE workflow for OAuth 2 authentication. Bugs/Housekeeping: Fixed an issue where windows installer is not signing tmp files generated by InnoSetup. Fixed an issue in the Search Objects tool where selecting a node occasionally selected an incorrect node. Improved the application state restoration by leveraging rc-dock layout and ensure the order and layout of tabs is maintained on restore. Fixed an issue where json editor in result grid was crashing if null value is set in the json editor. Update zstd library link to 1.5.7 in Dockerfile. Ensure that pgAdmin 4 is compatible with PG/EPAS v18. Use 'Drop' instead of 'Delete' for object commands to make destructive actions more deliberate. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.5. This release of pgAdmin 4 includes 18 bug fixes and new features. For more details, please see the release notes. Note:The publication of the Python package to ... [More] PyPi has been delayed and will be completed as soon as possible. Notable changes in this release include: Features: Add a new permission to allow disabling the "Change Password" feature for a pgAdmin role. Added role-based restrictions for editing server connections. Added support for customizing keyboard shortcuts in the Query Tool's Edit menu. Add a search box to enable searching within the preferences tab. Added support to preserve the workspace, query windows, and pgAdmin state during an abrupt shutdown or restart. Open preferences in a new tab instead of a dialog for a better user experience. Supports JSON logging for gunicorn process within Docker. Bugs/Housekeeping: Improved PL/pgSQL code folding and support nested blocks. Add a flag to allow access to system Python packages on recent Linux distributions. Fixed an issue where utilities such as pg_dump and pg_restore failed to log error messages when required dependency files were missing. Fixed an issue where the Schema Diff Tool incorrectly reported differences due to variations in the order of the privileges. Fixed an issue in SQL syntax highlighting where the same color was used for both variable names and datatypes. Fixed an issue in the query tool where using multiple cursors to copy text resulted in only the first line being copied. Fixed an issue where data export using a query opened the wrong dialog type. Fixed an issue where data export using a query failed when the query contained a newline character. Fixed a UI layout issue that occurred after upgrading from pgAdmin v9.2 when all tabs had been closed prior to the upgrade. Fixed an issue where the Columns node was not visible under Catalog Objects. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.4. 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: Enabled ... [More] large file downloads for desktop users within the query tool. Add all missing options to the Import/Export Data functionality, and update the syntax of the COPY command to align with the latest standards. Add support for exporting table data based on a custom query. Bugs/Housekeeping: Fixed an issue where the result grid slowed down when any column contained a large amount of data. Fix the issue where an error is displayed when a table is dropped while a query is running. Fixed an issue where the options key was not working as expected in the PSQL tool. Fixed an issue where correct error message not displayed when sql statement contains Arabic letters. Enhance contrast for selected and hovered items in the Object Explorer to improve visibility and accessibility. Fixed an issue where the query tool returns "cannot unpack non-iterable Response object" when running any query with a database name change. Handle result grid data changes in View/Edit Data mode by automatically reconnecting to the server if a disconnection occurs. Implement API fetch error display for select dropdown. Fixed an issue where light theme briefly appears when pgAdmin loads or tools open, even when a dark or system UI theme is preferred. Fixed issues related to column range selection using shift + click. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.3. This release of pgAdmin 4 includes 4 new features and 14 bug fixes/housekeeping changes. For more details, please see the release notes. Notable changes in this release ... [More] include: Features: Add support for type constructors for PostGIS spatial types. Added ability to use SQL in the "DB Restriction" field. Add support for custom roles and role permissions management in pgAdmin. Added support for font ligatures. Bugs/Housekeeping: Add Cache-Control no-cache,no-store,must-revalidate header to dynamically generated utils.js file. Fixed an issue where shift + click on rows/columns for range selection did not work in the query tool data output window. Fixed an issue where the debugger hangs when stepping into nested function/procedure. Ensure that graph data is updated even when the Dashboard tab is inactive. Fixed an issue where Ctrl/Cmd+A in cell editor would select all rows. Fixed an issue where drag and drop function with no parameters does not work. Fixed an issue where changes to foreign key constraints were not detected in the schema diff. Fixed an issue where the query tool went blank when converting history dates to the appropriate locale format. Fixed an issue where the user management tab is not opening in the classic layout. Allow OAuth 2 login using the username claim if the email is absent from the user profile. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.2. 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 an ... [More] ability to configure the font family for SQL editors. Added support to automatically open a file after it is downloaded in the desktop mode. Added support for post-connection SQL execution, which will be run automatically on each connection made to any database of the server. Add support for restoring plain SQL database dumps. Added support for creating Directory nodes in EPAS. Change icon buttons to show tooltips even when disabled. Add an option to load/replace the servers.json file on each container startup. Open user management in a separate tab instead of a dialog to enhance UI/UX. Bugs/Housekeeping: Fixed an XSS vulnerability issue in the Query Tool and View/Edit Data (CVE-2025-2946). Fixed a remote code execution issue in the Query Tool and Cloud Deployment (CVE-2025-2945). Ensure that modal dialogs are not triggered more than once to avoid duplicates. Fixed an issue where pgAdmin should fallback to the main screen if the last opened screen is disconnected. Fixed an issue where the PSQL terminal displays keyname for non-alphanumeric keys. Change the stop/terminate icon at all the places for better UX. Fixed an issue where the query tool data grid did not respect the default value for columns of domain type when the domain had a default value. Ensure the newly added parameters in the server dialog are incorporated into the Import/Export Servers functionality. Fixed an issue where the query tool is crashing on macOS 15.4 due to a locale issue. Fixed an issue where the upgrade_check API returned an unexpected keyword argument 'cafile' due to changes in the urllib package supporting Python v3.13. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.1. This release of pgAdmin 4 includes 14 bug fixes and new features. For more details, please see the release notes. Notable changes in this release include: Features: Added an ... [More] option to open the file in a new tab within the query tool. Add support for one-to-one relationship in the ERD tool. Enable the ability to close the 'Welcome' tab in the Query Tool/PSQL Workspace. Bugs/Housekeeping: Added support for Python 3.13. Fixed an issue where pgAdmin does not support pg_vector column length/precision. Fixed an issue where pasting text containing JSON data into the query tool grid would result in incorrect parsing. Fixed an issue where the query tool was not treating IDENTITY columns as columns with default values when inserting new rows. Fixed an issue where the ERD tool failed to open a saved file containing parent-child relationships within the same table. Fixed Docker image entrypoint.sh email validation. Fixed an issue where the User Management and Change Password dialogs were hidden when selecting a menu while a workspace other than 'Default' was active. Fixed an issue where the column order displayed was incorrect for exclusion constraints with multiple columns. Fixed an issue where deleting rows in the query tool would delete all rows in the table when 'Select All Remaining Rows' was used. Ensure the saved passwords are decrypted with the correct encryption key for external authentication in server mode. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.0. This release of pgAdmin 4 includes 25 bug fixes and new features. For more details please see the release notes. Note:(Windows only) In this release, the 'vX' suffix has ... [More] been removed from the application name. You will now see 'pgAdmin 4' as the app name. Starting from version 8, we also removed the 'vX' folder from the default installation path, allowing users to seamlessly upgrade to major versions. As a result of this change, if version 8 is already installed on the machine, the uninstaller will first run, followed by the installation of version 9. Notable changes in this release include: Features: Enhanced pgAdmin 4 with support for Workspace layouts. Starting with this release, pgAdmin introduces two layout options: the Classic layout, a familiar design users know well, and the new Workspace layout, which provides a streamlined, distraction-free environment with dedicated areas for the Query Tool, PSQL, and Schema Diff tools. The Workspace layout is set as the default, but users can easily switch to the Classic layout through the preferences. In the Workspace layout, the Query Tool, PSQL, and Schema Diff tabs are organized and opened within their respective workspaces for a more focused experience. Added the MAINTAIN privilege for PostgreSQL version 17 and above. Add support for OAuth2 profile array response, which handles the GitHub Private Email ID issue. Change button labels and color in the delete confirmation dialog for all objects to improve UX. Bugs/Housekeeping: Fixed an issue where pgadmin cannot install into the path with non-ASCII characters. Fixed an issue where filter dialog save fails when the PostgreSQL server/database connection is lost. Fixed an issue where an error message from the database server needs space between two sentences. Fixed an issue where the query tool throws utf-8 decode error when using a cursor with binary data. Fixed an issue where the option key was not registering in the PSQL tool. Fixed an issue where copying query tool output cell is not working if any SQL text is selected. Remove the option "With no data (concurrently)" from the Refresh MATERIALIZED VIEW context menu. Fixed an issue where Default Privileges and Privileges not working correctly. Fixed an issue where quotes were missing in the CREATE script for the tablespace. Change the logic of the setval function, so that the next nextval of sequence will return exactly the specified value. Download your copy now! [Read News] [Less]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.14. This release of pgAdmin 4 includes 23 bug fixes and new features. For more details please see the release notes. Notable changes in this release include: Features: Added ... [More] support for adding tags on a server node. Allow setting NULL ordering for columns in view/edit data filter dialog. Show auto-complete column names in filtered rows dialog of table and filter options of view/edit data tool. Allow the use of a pgpass file in the pgAdmin container via Docker secrets. Add support for passing connection details as placeholders in the passexec command. Add support to deploy pgAdmin in a container with readOnlyRootFilesystem to true. Added support for a builtin locale provider in the Database dialog. Bugs/Housekeeping: Fixed an issue where Ctrl/Cmd + A was not selecting all data in query tool data grid. Fixed an issue where querying a foreign table gives the error 'ForeignTableCommand' object has no attribute 'auto_commit'. Fixed an issue where pgAdmin crashes on accessing the dashboard state tab when database is super busy. Fixed an issue where a column name change in the edit dialog of the table node does not show the updated column name. Ensure the crypt key is retrieved correctly on backend server restart. Fixed an issue in schema diff where an error message popup was showing some garbage without any info. Add a user preference to enable/disable alternating row background colors in the data output of query tool. Fixed an issue where doing Ctrl/Cmd+C on a selected text in a cell editor of data output in the query tool copied the complete text. Fixed an issue where auto-width of wide columns in data output is incorrectly calculated. Ensure correct custom SSL certificate passed in connection string. Download your copy now! [Read News] [Less]

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]