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

2024-05-30 - pgAdmin 4 v8.7 Released

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

Notable changes in this release include:

Features:

• Added support for the 'Add to macros' feature and fixed various usability issues.
• Added support for executing the query at the cursor position in the query tool.
• Changes in Query Tool, Debugger, and ERD Tool shortcuts to remove the use of Accesskey which will allow them to be customized.
• Added support for viewing PGD Clusters.
• Enhance the Delete dialog by highlighting the names of the objects to be deleted in bold.
• Added support for platform Ubuntu 24.04 and Fedora 40.

Bugs/Housekeeping:

• Upgrade react-table from v7 to v8.
• Ensure that Schema Diff does not indicate a table as different when the trigger names are the same but the trigger function body is different.
• Fixed an issue of the pgAdmin window size increasing each time it was reopened.
• Update the documentation for preferences dialog and keyboard shortcuts.
• Fixed an issue where pgAdmin fails to start when Ubuntu OS is upgraded to a major version.
• Fixed incorrect highlighting for C-Style escape strings in SQL editor.
• Fixed an issue where the recover password button was enabled even when no email was provided.
• Fixed an issue where resetting the password from the password reset link was not working.

Download your copy now!

2024-05-02 - pgAdmin 4 v8.6 Released

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

• Added the new columns "last_seq_scan" and "last_idx_scan" from the pg_stat_all_tables and pg_stat_all_indexes tables respectively to the Statistics tab.
• Added support for excluding multiple tables while taking Backup.

Bugs/Housekeeping:

• Fixed an XSS vulnerability in the /settings/store endpoint (CVE-2024-4216).
• Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215).
• Update UI library MUI from v4 to v5.
• Upgraded Flask, Flask-Security-Too, Werkzeug, and other dependencies, ensuring compatibility with Python 3.7.
• Fixed violates check constraint issue when creating a pgAgent schedule.
• Fixed an issue where pressing backspace should remove the spaces and not the entire tab width, on enabling 'Use spaces?' in the preferences.
• Fixed an issue where incorrect select/exec scripts were generated for functions/procedures.
• Fixed an issue when closing the view data second tab; it raises the error that the 'ViewCommand' object has no attribute 'auto_commit'.
• Install dbus-python, an in-direct dependency of the Keyring package as a system package for Debian platforms.

Download your copy now!

2024-04-04 - pgAdmin 4 v8.5 Released

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

Notable changes in this release include:

Features:

• Added support for EDB Job Scheduler.
• Added support for viewing Log Based Clusters.
• Added support for UNIX socket in entrypoint.sh for Docker implementation.
• Added support for provider, deterministic, version, and RULES parameters while creating collation.

Bugs/Housekeeping:

• Fixed a remote code execution issue in the validate binary path (CVE-2024-3116).
• Fixed an issue in Schema Diff where Columns with sequences get altered unnecessarily.
• Fixed schema diff wrong query generation for the table, foreign table, and sequence.
• Fixed an issue where the maximize icon is missing from the query tool panel.
• Fix an issue in editor where Format SQL shortcut and multiline selection are not working.
• Fix an issue in the editor where the "Use Spaces?" preference of the Editor is not working.
• Fixed an issue where Triggers, Rules, and Indexes were absent from the Schema Diff when comparing views.
• Fixed an issue where taking a backup of a shared server was using the server owner's user name.
• Fix an issue in the query tool where custom keyboard shortcuts are not working for some.

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.