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

The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.11. 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:

• Add support of DEPENDS/NO DEPENDS ON EXTENSION for INDEX.
• Add support of DEPENDS/NO DEPENDS ON EXTENSION for MATERIALIZED VIEW.
• Add support for showing the column data type beside column name in the object explorer.
• Added Ubuntu 25.10 and Fedora 43.
• Add conditional TLS support for the Ingress in the Helm chart.

Bugs/Housekeeping:

• Plain SQL restore runs with '\restrict' option to prevent harmful psql meta-commands (CVE-2025-13780).
• Fixed an issue on type casting of default string function/procedure arguments in debugger tool.
• Fix pkg_resources deprecation warning by migrating Docker base image to python:3-alpine from alpine:latest.
• Fixed an issue where EXPLAIN should run on query under cursor if no text is selected.
• Fixed an issue where opening file in Query Tool does not retain file name in tab.
• Fixed an issue where connection is failing via Query Tool/PSQL Tool workspaces.
• Fixed an issue where copying highlighted text in the query tool data output cell editor would copy the complete string.
• Fixed an issue where copying a single cell should not add quoting.
• Fix the Helm chart server definition and change the app version.
• Specify the correct hostname placeholder for the Password Exec command.
• Ensure the proper handling of extra volume mount configurations in the Helm deployment template by correcting the configuration value references.

Download your copy now!

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!

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