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-08-21 - pgAdmin 4 v9.7 Released

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:

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!

2025-07-25 - pgAdmin 4 v9.6 Released

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

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!

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