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

2023-11-23 - pgAdmin 4 v8.0 Released

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

Note:

This is a new major version of pgAdmin 4. In this upgraded version, we've incorporated updates to essential components such as Flask, Werkzeug, and various other modules. Notably, the default installation path for Windows operating systems has changed, and the version folder has been eliminated. Consequently, users are advised to perform a manual uninstallation of the previous version for a seamless transition to the new release.

Notable changes in this release include:

Features:

• Replace the current layout library wcDocker with ReactJS based rc-dock.
• Changes in the context menu on panel tabs - Add close, close all and close others menu items.
• Allow closing all the tabs, including SQL and Properties.
• Have close buttons on individual panel tabs instead of common.

Bugs/Housekeeping:

• Upgrade Flask, Werkzeug and other modules depends on the latest version of Flask.
• Add DROP SQL for foreign keys in SQL generated by ERD when using WITH DROP option.
• Fixed an issue where psql was not taking the role used to connect in server properties.
• Fixed an issue where Geometry Viewer renders geometry incorrectly after trying to view 3D or non-4326 SRID geometry.
• Fix an issue where the default server-group is being deleted if the load-server json file contains no servers.
• Fixed an issue where Schema Diff does not work when the user language is set to any language other than English in Preferences.
• Fix an issue where OAUTH_ADDITIONAL_CLAIMS does not recognise AzureAD with > 150 groups.
• Fix an issue where import/export data is not working for shared servers.
• Fix a crash issue occurring when debugging a function with arguments when using pgAdmin with external config database.
• Fixed an issue where the change server password is not working in desktop mode.

Download your copy now!

2023-10-19 - pgAdmin 4 v7.8 Released

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

Notable changes in this release include:

Features:

• GUI representation of the system's activity using the 'system_stats' extension

This feature is used to see the GUI representation of the system's activity using the 'system_stats' extension. Added a new tab 'System Statistics' under the Dashboard tab. This new tab contains the details about CPU, Memory, and Storage.

• Add support for foreign table's new functionality for PG 11 and above.
• Allow setting custom username for shared servers, with default as username of server being shared.
• Add 'GENERATED ALWAYS AS..' option while creating column constraints for Foreign Table
• Added 'load_balance_hosts' connection string parameter for PG 16 and above.

Bugs/Housekeeping:

• Fixed an issue in ERD tool where the downloaded images have a few links cut.
• Fixed an issue where user was not able to assign new/old columns as primary key once column with primary key is deleted.
• Add support for setting prepare threshold in server connection.
• Fix an issue where global/native keyboard shortcuts are not working when any cell of data output grid has focus.
• Fixed query history slowness issue by storing query only for those having certain threshold max length.
• Ensure that the backup works properly for PG 16 on the latest docker image.
• Fixed an issue where non-super PostgreSQL users are not able to terminate their own connections from dashboard.
• Fix an issue where scale in columns is not allowed to have value as 0 or below.
• Fix an issue in graphical explain plan where query tool crashes when the plan has parallel workers details and sort node is clicked for details.
• Fix an issue where user login is not working if username/email contains single quote in server mode.

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.