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-06-30 - pgAdmin 4 v9.5 Released

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

2025-05-29 - pgAdmin 4 v9.4 Released

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

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!

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