Latest Videos

Want to see your pgAdmin video here? Email webmaster@pgadmin.org.

All videos

Latest Blog Posts

Customising your pgAdmin 4 workspace - Part 1: Browser

Author: Anil Sahoo, date: Aug. 24, 2023

If you are reading this then you are probably using pgAdmin as a tool to help in your day to day database management activities with PostgreSQL. But, did you know there are a variety of ways you can maximise your productivity by customising the pgAdmin workspace using the Preferences dialog’s various options? This article will show you some of the options for customising the workspace using the Browser node of the Preferences tree control.

Read more

pgAdmin User Management in Server Mode

Author: Aditya Toshniwal, date: Aug. 24, 2023

pgAdmin can be deployed as a web application by configuring the app to run in server mode. One can check out server deployment on how to run pgAdmin in server mode. In this blog, we will discuss how to manage the pgAdmin users when running in server mode.

Read more

pgAdmin CI/CD

Author: Dave Page, date: Aug. 24, 2023

Almost exactly three years ago I wrote a blog on my personal page entitled Testing pgAdmin which went into great detail discussing how we test pgAdmin prior to releases. Back then, all of the automated testing was performed using Jenkins, with a number of jobs that ran various test suites whenever new code was checked in. All of this infrastructure ran in a virtual private cloud on AWS consisting of a large number of virtual machines and other resources, hosted for the project by EDB. I recently undertook a project to move the testing infrastructure to our Github project, using Github Actions.

Read more

News

2025-04-30 - pgAdmin 4 v9.3 Released

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 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!

2025-04-03 - pgAdmin 4 v9.2 Released

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 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!

2025-03-03 - pgAdmin 4 v9.1 Released

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 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!

2025-02-06 - pgAdmin 4 v9.0 Released

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 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!

Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.