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-02-06 - pgAdmin 4 v9.0 Released

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

Note:(Windows only)

In this release, the 'vX' suffix has been removed from the application name. You will now see 'pgAdmin 4' as the app name. Starting from version 8, we also removed the 'vX' folder from the default installation path, allowing users to seamlessly upgrade to major versions. As a result of this change, if version 8 is already installed on the machine, the uninstaller will first run, followed by the installation of version 9.

Notable changes in this release include:

Features:

• Enhanced pgAdmin 4 with support for Workspace layouts.

Starting with this release, pgAdmin introduces two layout options: the Classic layout, a familiar design users know well, and the new Workspace layout, which provides a streamlined, distraction-free environment with dedicated areas for the Query Tool, PSQL, and Schema Diff tools. The Workspace layout is set as the default, but users can easily switch to the Classic layout through the preferences. In the Workspace layout, the Query Tool, PSQL, and Schema Diff tabs are organized and opened within their respective workspaces for a more focused experience.

• Added the MAINTAIN privilege for PostgreSQL version 17 and above.
• Add support for OAuth2 profile array response, which handles the GitHub Private Email ID issue.
• Change button labels and color in the delete confirmation dialog for all objects to improve UX.

Bugs/Housekeeping:

• Fixed an issue where pgadmin cannot install into the path with non-ASCII characters.
• Fixed an issue where filter dialog save fails when the PostgreSQL server/database connection is lost.
• Fixed an issue where an error message from the database server needs space between two sentences.
• Fixed an issue where the query tool throws utf-8 decode error when using a cursor with binary data.
• Fixed an issue where the option key was not registering in the PSQL tool.
• Fixed an issue where copying query tool output cell is not working if any SQL text is selected.
• Remove the option "With no data (concurrently)" from the Refresh MATERIALIZED VIEW context menu.
• Fixed an issue where Default Privileges and Privileges not working correctly.
• Fixed an issue where quotes were missing in the CREATE script for the tablespace.
• Change the logic of the setval function, so that the next nextval of sequence will return exactly the specified value.

Download your copy now!

2024-12-12 - pgAdmin 4 v8.14 Released

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

Notable changes in this release include:

Features:

• Added support for adding tags on a server node.
• Allow setting NULL ordering for columns in view/edit data filter dialog.
• Show auto-complete column names in filtered rows dialog of table and filter options of view/edit data tool.
• Allow the use of a pgpass file in the pgAdmin container via Docker secrets.
• Add support for passing connection details as placeholders in the passexec command.
• Add support to deploy pgAdmin in a container with readOnlyRootFilesystem to true.
• Added support for a builtin locale provider in the Database dialog.

Bugs/Housekeeping:

• Fixed an issue where Ctrl/Cmd + A was not selecting all data in query tool data grid.
• Fixed an issue where querying a foreign table gives the error 'ForeignTableCommand' object has no attribute 'auto_commit'.
• Fixed an issue where pgAdmin crashes on accessing the dashboard state tab when database is super busy.
• Fixed an issue where a column name change in the edit dialog of the table node does not show the updated column name.
• Ensure the crypt key is retrieved correctly on backend server restart.
• Fixed an issue in schema diff where an error message popup was showing some garbage without any info.
• Add a user preference to enable/disable alternating row background colors in the data output of query tool.
• Fixed an issue where doing Ctrl/Cmd+C on a selected text in a cell editor of data output in the query tool copied the complete text.
• Fixed an issue where auto-width of wide columns in data output is incorrectly calculated.
• Ensure correct custom SSL certificate passed in connection string.

Download your copy now!

2024-11-14 - pgAdmin 4 v8.13 Released

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

Notable changes in this release include:

Features:

• Replace infinite scrolling with pagination in query tool data output for better UX and performance.
• Add an object menu option to disconnect all server and database connections.
• Alternate the background color of rows to enhance readability.
• Allow to pass PGADMIN_CONFIG_CONFIG_DATABASE_URI from docker secrets.
• Format dashboard graph metrics for better readability.
• Added support for auto-detecting and setting the End-of-line character (LF/CRLF) in the query tool editor.
• Make the background color for the serial number and header cells distinct.

Bugs/Housekeeping:

• Updated the react-menu library from v2 to v4.
• Fixed an issue that allowed the Enter key to save data in the result grid text editor.
• Move 'About pgAdmin 4' to the app menu on macOS.
• Fixed an issue where the query tool was crashing when an empty geometry was being rendered.
• Fixed an issue where the Dashboard tab showed 'Something went wrong'.
• Fixed an issue where cursor selection is not visible in the PSQL tool.
• Allow OAuth2 params OAUTH2_NAME, OAUTH2_DISPLAY_NAME, OAUTH2_ICON, OAUTH2_BUTTON_COLOR to be optional.
• Add appropriate minimum width and height settings for desktop apps to avoid apps accidentally going below visibility levels.
• Fixed an issue where the graphical explain kept the node details open even after the plan changed.
• Fixed an issue in the debugger where the character data type function arguments were being truncated.

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.