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-11-13 - pgAdmin 4 v9.10 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.10. This release of pgAdmin 4 includes 5 new features and 12 bug fixes/housekeeping changes. For more details, please see the release notes.

Notable changes in this release include:

Features:

• Added the ability to search for tables and automatically bring them into view in the ERD tool.
• Add support of DEPENDS/NO DEPENDS ON EXTENSION for PROCEDURE.
• Add support for setting image download resolution in the ERD tool.
• Add support for displaying detailed Citus query plans instead of 'Custom Scan' placeholder.
• Add support for formatting .pgerd ERD project file.

Bugs/Housekeeping:

• Fixed an issue where data output column resize is not sticking in Safari.
• Fixed an issue where Schema Diff does not ignore Tablespace for indexes.
• Fixed an issue where the 2FA window redirected to the login page after session expiration.
• Fixed an issue where the Select All option on the columns tab of import/export data was not working in languages other than English.
• Fixed an issue where the Debian build process failed with a "Sphinx module not found" error when using a Python virtual environment.
• Fixed an issue where the last used storage directory was reset to blank, leading to access denied errors during backup or restore operations.
• Fixed an issue that prevented assigning multiple users to an RLS policy.
• Fixed remote code execution vulnerability when restoring PLAIN-format SQL dumps in server mode (CVE-2025-12762).
• Fixed Command injection vulnerability allowing arbitrary command execution on Windows (CVE-2025-12763).
• Fixed LDAP authentication flow vulnerable to TLS certificate verification bypass (CVE-2025-12765).
• Fixed LDAP injection vulnerability in LDAP authentication flow (CVE-2025-12764).
• Migrate pgAdmin UI to use React 19.

Download your copy now!

2025-10-16 - pgAdmin 4 v9.9 Released

The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.9. This release of pgAdmin 4 includes 10 bug fixes and new features. For more details, please see the release notes.

Notable changes in this release include:

Features:

• Add support of DEPENDS/NO DEPENDS ON EXTENSION for ALTER FUNCTION.
• Added "MULTIRANGE_TYPE_NAME" option while creating a Range Type.
• Added "SUBSCRIPT" option while creating an External Type.
• Added option to skip the password dialog when using an identity file.
• Added 'failover' and 'two_phase' parameter support in CREATE/ALTER SUBSCRIPTION for PostgreSQL v17+.
• Add support for initializing the pgAdmin4 Kubernetes Helm chart.

Bugs/Housekeeping:

• Fixed an issue where the query tool displayed 'default' instead of 'null' for null text data in the data output.
• Fixed an issue where the pgAdmin configuration database wasn't being created on a fresh install when an external database was used for the configuration.
• Fixed an issue where shortcuts are not working as expected on multiple keyboard layouts.
• Fixed an issue where saving the newly changed preferences was not reflecting on the preferences tab.

Download your copy now!

2025-09-04 - pgAdmin 4 v9.8 Released

The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.8. This release of pgAdmin 4 includes 10 bug fixes and new features. For more details, please see the release notes.

Notable changes in this release include:

Features:

• Add menu items for truncating foreign tables.
• Added Debian Trixie as a supported platform for pgAdmin.
• Allow user to configure security related gunicorn parameters.
• Change the default pgAdmin theme to System.

Bugs/Housekeeping:

• Fixed Cross-Origin Opener Policy (COOP) vulnerability in the OAuth 2.0 authentication flow (CVE-2025-9636).
• Remove usage of BrowserFS as it is deprecated.
• Pin Paramiko to version 3.5.1 to fix the DSSKey error introduced in the latest release.
• Fixed an issue where pgAdmin config migration was failing while upgrading to v9.7.
• Fixed an issue where editor shortcuts fail when using Option key combinations on macOS, due to macOS treating Option+Key as a different key input.
• Fixed an issue where the pgAdmin configuration database wasn’t being created on a fresh install when an external database was used for the configuration.

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.