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

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!

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