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-08-22 - pgAdmin 4 v8.11 Released

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

• Add a home button to the geometry viewer to set the original zoom level when the viewer is opened.

Bugs/Housekeeping:

• Fixed an issue where refreshing the Schema Diff tool opened in a new tab caused an error.
• Fix server heartbeat logging error after deleting the server.
• Fixed an issue where the Generate Script ignored filter conditions when a parent node was selected.
• Fixed an issue where delete object(shortcut key) affected both text and Object Explorer items.
• Fix an issue where the ERD tool should be able to open saved pgerd file when using keyboard shortcuts.
• Fixed an issue where the REVOKE statement in the create script was throwing an error if the role contained special characters.
• Improve code highlighting in the query editor.
• Fix an issue where the wheel package is not getting installed on the arm64-based macOS version < 14.
• Fixed an issue where column resizing is not working in the search objects dialog
• Fixed an issue where the value in the find box is not updating with selected text in the editor if the find is already open and re-triggered.

Download your copy now!

2024-07-29 - pgAdmin 4 v8.10 Released

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

Note: With this release, pgAdmin 4 has transitioned from NW.js to Electron

Notable changes in this release include:

Features:

• Add support for Postgres Server Logs for Text, CSV, and JSON format in plain and tabular formats.
• Add support for highlighting selection matches in the query editor.
• Add a keyboard shortcut to close the active tab panel.

Bugs/Housekeeping:

• Replace pgAdmin NW.js container with Electron container.
• Ensure that pgAdmin 4 is compatible with PostgreSQL v17.
• Fixed an issue where paste operation in query tool data grid should skip bytea columns and put the value as NULL instead.
• Ensure pgAdmin never makes network requests to Google etc.
• Fixed the permission denied issue for functions of the pgstattuple extension when accessing statistics with a non-admin user.
• Updated entrypoint.sh to utilize the email-validator package for email validation.
• Fixed an issue where users could not insert characters at the desired location, as it was added to the end of the line.
• Fixed an issue where users could not autofill their saved passwords in the connect server dialog in the browser.
• Fixed an issue where boolean values in node details of the graphical explain plan were not interpreted correctly.
• Ensure that pgAdmin works when opened in an iframe.

Download your copy now!

2024-06-27 - pgAdmin 4 v8.9 Released

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

Notable changes in this release include:

Features:

• Provide the option to set a theme based on OS theme preference.

Bugs/Housekeeping:

• Remove the usage of MUI makeStyles as it doesn't support React 18.
• Fix the permissions issue in the pgAdmin installation directory on Debian and RHEL-8 platforms (CVE-2024-6238).
• Fixed an issue where resizable data editors in the query tool should not be allowed to resize beyond the app window bounds.
• Ensure that a user can connect to a server using SSL certificates and identity files from a shared storage.
• Fixed an issue where the dark theme shows a white background when all tabs are closed.
• Fixed an issue where the schema diff incorrectly marked tables as different due to schema-qualified trigger functions in the trigger definitions.
• Fixed an issue where backslash breaks syntax highlighting.
• Fixed an issue where query tool shortcuts for find/replace are not working.
• Fixed new line indentation in the query editor and added a user preference to disable it.
• Fixed migration failure while using an external database.

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.