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

2024-03-07 - pgAdmin 4 v8.4 Released

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

Notable changes in this release include:

Features:

• Allow preferences customization using a configuration file.
• Add support for JSON log format.
• Add --yes option for skipping the confirmation prompt while deleting the user via CLI for scripting purposes.

Bugs/Housekeeping:

• Unsafe Deserialization and Remote Code Execution by an Authenticated user in pgAdmin 4 (CVE-2024-2044).
• Upgrade CodeMirror from version 5 to 6.
• Fix multiple issues where PasswordExecCommand was not working in server mode and PasswordExecCommand was not loaded when importing servers.
• Fix the tabbed panel backward/forward shortcut for tabs.
• Fixed an issue where dependencies and dependents were not showing if a composite type was used as an attribute in another composite type.
• Remove role-related checks on the UI dashboard when terminating a session/query and let PostgreSQL take care of it.
• Fix an issue where the scripts created by generating script of Schema diff for Table with sequence was not working earlier.
• Added documentation for Dashboard's System Statistics tab.
• Ensure that the OAuth2 session is logged out when users log out from pgAdmin.

Download your copy now!

2024-02-09 - pgAdmin 4 v8.3 Released

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

Notable changes in this release include:

Features:

• Allow drag-n-drop column’s collection tree node as comma-separated columns.
• Added support to rename columns in Views.
• Added BYPASSRLS|NOBYPASSRLS option while creating a Role.
• Added support for column storage syntax while creating table.
• Use COOKIE_DEFAULT_PATH or SCRIPT_NAME in the session cookie path.
• Added configurable parameter to enable support for PasswordExecCommand in server mode.

Bugs/Housekeeping:

• Fixed an issue where format SQL was messing up the operator. Included many other feature changes.
• Fixed an issue where formatting inserts empty lines in specific cases.
• Add support for selecting a schema in the backup database dialog with no tables, mviews, views, or foreign tables.
• Fixed a UI border issue on the dependencies tab for columns with icons.
• Fixed an issue where multiple errors were showing if the user did not have connect privileges.
• Fixed an issue where group membership information was displayed incorrectly.
• Ensure that the correct SQL is generated when changing the column data type to "char".
• Fixed an issue pgAdmin fails to launch due to inconsistent PATH variable name on windows.
• Fix a backend server error when creating a named restore point.

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.