Semantic Coherence: pgAdmin – Signal Evidence & AI Readability

[H2] Why Choose pgAdmin?

[H3] Cross-Platform

Run on Windows, macOS, Linux, or deploy as a web application accessible from any browser.

[H3] Full Database Management

Create, manage, and query all PostgreSQL objects with an intuitive graphical interface.

[H3] Powerful Query Tool

Syntax highlighting, auto-complete, and graphical EXPLAIN for optimizing your queries.

See All Features

[H6] How to use Restore Dialog in pgAdmin 4

[H6] Authenticate pgAdmin 4 with Github

[H6] Kerberos and Active Directory setup in pgAdmin 4

Want to see your pgAdmin video here? Email webmaster@pgadmin.org.

Anil Sahoo
|
Aug. 24, 2023

[H5] Customising your pgAdmin 4 workspace - Part 1: Browser
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 …
Read More

Aditya Toshniwal
|
Aug. 24, 2023

[H5] pgAdmin User Management in Server Mode
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 …
Read More

Dave Page
|
Aug. 24, 2023

[H5] pgAdmin CI/CD
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 …
Read More

Want to see your pgAdmin blog post here? Email webmaster@pgadmin.org.

2026-05-11

[H5] pgAdmin 4 v9.15 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.15. This release of pgAdmin 4 includes 19 bug fixes and new features, including fixes for eight security vulnerabilities (CVE-2026-7813 through CVE-2026-7820). For more details, please see the release notes.

pgAdmin is the leading open-source graphical management tool for PostgreSQL. For more information, please see the website.

Notable changes in this release include:

[H2] Features:

Allow the Docker container image to run as a non-default user via the PUID and PGID environment variables.

[H2] Bugs/Housekeeping:

Fix cross-user data access and shared-server privilege escalation in server mode (CVE-2026-7813).
Tighten Shared Server feature parity, owner-only field handling, and write guards as a follow-up to the data-isolation hardening.
Fix stored cross-site scripting (XSS) via crafted PostgreSQL object names rendered in the Browser Tree and Explain Visualizer (CVE-2026-7814).
Fix SQL injection in the Maintenance tool option values (CVE-2026-7815).
Fix OS command injection in Import/Export query export (CVE-2026-7816).
Fix local-file inclusion and server-side request forgery in the LLM API configuration endpoints (CVE-2026-7817).
Fix unsafe deserialization in the session manager that could lead to remote code execution (CVE-2026-7818). This change also encrypts session files at rest using Fernet, restricts session-file and DATA_DIR permissions to 0o600, switches the session-digest default from SHA-1 to SHA-256, and drops several non-roundtrippable live objects from the session.
Fix symlink-based path traversal in the file manager (CVE-2026-7819).
Fix account-lockout bypass on Flask-Security's default /login view so the locked field is honored on every authentication path (CVE-2026-7820).
Use absolute paths for a2enmod and a2enconf in the Debian setup script so it works when /usr/sbin is not on PATH.
Bump Python and JavaScript runtime/development dependencies, and upgrade ESLint to v10.
Update the Czech, Italian, Russian, Spanish, and Swedish translations.

[H2] Deprecations:

The BigAnimal cloud deployment integration is deprecated and will be removed in the next version of pgAdmin 4.

Builds for Windows and macOS are available now, along with a Python Wheel, Docker Container, RPM, DEB Package, and source code tarball from the tarball area.

2026-04-02

[H5] pgAdmin 4 v9.14 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.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 to download binary data from the result grid.
Added support for custom LLM provider URLs for OpenAI and Anthropic, allowing use of OpenAI-compatible providers such as LM Studio, EXO, and LiteLLM.
Fixed an issue where AI features (AI Assistant tab, AI Reports menus, and AI Preferences) were visible in the UI even when LLM_ENABLED is set to False.
Allow copying of text from the AI Assistant chat panel.

Bugs/Housekeeping:

Fixed an issue where selecting all in the Query Tool's Messages tab would select the entire page content.
Fixed an issue where OAuth2 authentication fails with 'object has no attribute' if OAUTH2_AUTO_CREATE_USER is False.
Ensure that the Geometry Viewer refreshes when re-running queries or switching geometry columns, preventing stale data from being displayed.
Fixed an issue where the default fillfactor value for B-tree indexes was incorrect.
Fixed an issue where AI Reports are grayed out after setting an API key by auto-selecting the default provider.
Fixed an issue where AI Assistant does not notify that No API Key or Provider is Set.
Fixed an issue where AI Reports fail with OpenAI models that do not support the temperature parameter.
Improve the AI Assistant user prompt to be more descriptive of the actual functionality.
Fix an issue where the AI Assistant was not retaining conversation context between messages, with chat history compaction to manage token budgets.
Support /v1/responses for OpenAI models.

Download your copy now!

2026-03-05

[H5] pgAdmin 4 v9.13 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.13. 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:

Core LLM integration infrastructure, AI reports for security, schema, and performance, AI chat for the Query Tool, and AI Insights for EXPLAIN.
No FK are shown in diagrams created from existing tables in the ERD Tool.
Add support for 'ONLY' in the Index creation dialog.
Allow users to customize "OF TYPE" columns during table creation.
Allow "drag-n-drop" for only user chosen tables, and show relations between them.
Load predefined users from a JSON file through the command line.

Bugs/Housekeeping:

Fixed an issue where the 'Quote strings only' configuration was ignored when downloading the result set.
Fixed an issue where tools settings changed by the users were not restored on application relaunch.
Fixed an issue where modifying a shared server incorrectly updated the original server details.
Fixed an issue where a long name in ERD table node was not breaking into multiple lines.
Fixed an issue where column comments were not displayed in the SQL tab for materialised views.
Fix an issue where deployment of the helm chart was crashing with "operation not permitted."
Fix translation compilation.
Fix broken checkbox selection in backup dialog's object tree.
Fixed an issue in file dialog where renaming was not working.

Download your copy now!

Current Version: pgAdmin 4 9.15

Download Now

[H1] Download
pgAdmin is a free software project released under the PostgreSQL licence. The
software is available in source and binary format from the
PostgreSQL mirror network. Because compiling from source
requires technical knowledge, we recommend installing binary packages whenever possible.
The pages in this section give additional details about each binary package available as well as more direct
download links. In addition, you can download source tarballs and pgAgent for your servers to enable additional
functionality.
Only recent downloads are kept on the main download site, along with the last release of each major version.
Older downloads can be found in the Download Archive.
Note that whilst the packages from the APT and YUM repositories are also archived here, the repository metadata
is not maintained so it is not possible to configure the archives as working repositories.
[H2] pgAdmin 4
pgAdmin 4 is a complete rewrite of pgAdmin, built using Python, ReactJs, and Javascript. A desktop runtime written in Electron allows it to run standalone for individual users, or the web application code may be deployed directly on a web server for use by one or more users through their web browser. The software has the look and feel of a desktop application whatever the runtime environment is, and vastly improves on pgAdmin III with updated user interface elements, multi-user/web deployment options, dashboards, and a more modern design.

Container

macOS

Python

APT

RPM

Source Code

Windows

[H2] pgAgent
pgAgent is a job scheduler for PostgreSQL which may be managed using pgAdmin. Prior to pgAdmin v1.9, pgAgent shipped as part of pgAdmin. From pgAdmin v1.9 onwards, pgAgent is shipped as a separate application.

APT

macOS

RPM

Windows

Source Code

[H1] News Archive

[H2] 2026-05-11 - pgAdmin 4 v9.15 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.15. This release of pgAdmin 4 includes 19 bug fixes and new features, including fixes for eight security vulnerabilities (CVE-2026-7813 through CVE-2026-7820). For more details, please see the release notes.

pgAdmin is the leading open-source graphical management tool for PostgreSQL. For more information, please see the website.

Notable changes in this release include:

[H2] Features:

Allow the Docker container image to run as a non-default user via the PUID and PGID environment variables.

[H2] Bugs/Housekeeping:

Fix cross-user data access and shared-server privilege escalation in server mode (CVE-2026-7813).
Tighten Shared Server feature parity, owner-only field handling, and write guards as a follow-up to the data-isolation hardening.
Fix stored cross-site scripting (XSS) via crafted PostgreSQL object names rendered in the Browser Tree and Explain Visualizer (CVE-2026-7814).
Fix SQL injection in the Maintenance tool option values (CVE-2026-7815).
Fix OS command injection in Import/Export query export (CVE-2026-7816).
Fix local-file inclusion and server-side request forgery in the LLM API configuration endpoints (CVE-2026-7817).
Fix unsafe deserialization in the session manager that could lead to remote code execution (CVE-2026-7818). This change also encrypts session files at rest using Fernet, restricts session-file and DATA_DIR permissions to 0o600, switches the session-digest default from SHA-1 to SHA-256, and drops several non-roundtrippable live objects from the session.
Fix symlink-based path traversal in the file manager (CVE-2026-7819).
Fix account-lockout bypass on Flask-Security's default /login view so the locked field is honored on every authentication path (CVE-2026-7820).
Use absolute paths for a2enmod and a2enconf in the Debian setup script so it works when /usr/sbin is not on PATH.
Bump Python and JavaScript runtime/development dependencies, and upgrade ESLint to v10.
Update the Czech, Italian, Russian, Spanish, and Swedish translations.

[H2] Deprecations:

The BigAnimal cloud deployment integration is deprecated and will be removed in the next version of pgAdmin 4.

Builds for Windows and macOS are available now, along with a Python Wheel, Docker Container, RPM, DEB Package, and source code tarball from the tarball area.

[H2] 2026-04-02 - pgAdmin 4 v9.14 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.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 to download binary data from the result grid.
Added support for custom LLM provider URLs for OpenAI and Anthropic, allowing use of OpenAI-compatible providers such as LM Studio, EXO, and LiteLLM.
Fixed an issue where AI features (AI Assistant tab, AI Reports menus, and AI Preferences) were visible in the UI even when LLM_ENABLED is set to False.
Allow copying of text from the AI Assistant chat panel.

Bugs/Housekeeping:

Fixed an issue where selecting all in the Query Tool's Messages tab would select the entire page content.
Fixed an issue where OAuth2 authentication fails with 'object has no attribute' if OAUTH2_AUTO_CREATE_USER is False.
Ensure that the Geometry Viewer refreshes when re-running queries or switching geometry columns, preventing stale data from being displayed.
Fixed an issue where the default fillfactor value for B-tree indexes was incorrect.
Fixed an issue where AI Reports are grayed out after setting an API key by auto-selecting the default provider.
Fixed an issue where AI Assistant does not notify that No API Key or Provider is Set.
Fixed an issue where AI Reports fail with OpenAI models that do not support the temperature parameter.
Improve the AI Assistant user prompt to be more descriptive of the actual functionality.
Fix an issue where the AI Assistant was not retaining conversation context between messages, with chat history compaction to manage token budgets.
Support /v1/responses for OpenAI models.

Download your copy now!

[H2] 2026-03-05 - pgAdmin 4 v9.13 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.13. 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:

Core LLM integration infrastructure, AI reports for security, schema, and performance, AI chat for the Query Tool, and AI Insights for EXPLAIN.
No FK are shown in diagrams created from existing tables in the ERD Tool.
Add support for 'ONLY' in the Index creation dialog.
Allow users to customize "OF TYPE" columns during table creation.
Allow "drag-n-drop" for only user chosen tables, and show relations between them.
Load predefined users from a JSON file through the command line.

Bugs/Housekeeping:

Fixed an issue where the 'Quote strings only' configuration was ignored when downloading the result set.
Fixed an issue where tools settings changed by the users were not restored on application relaunch.
Fixed an issue where modifying a shared server incorrectly updated the original server details.
Fixed an issue where a long name in ERD table node was not breaking into multiple lines.
Fixed an issue where column comments were not displayed in the SQL tab for materialised views.
Fix an issue where deployment of the helm chart was crashing with "operation not permitted."
Fix translation compilation.
Fix broken checkbox selection in backup dialog's object tree.
Fixed an issue in file dialog where renaming was not working.

Download your copy now!

[H2] 2026-02-05 - pgAdmin 4 v9.12 Released
The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.12. This release of pgAdmin 4 includes 3 new features and 21 bug fixes/housekeeping changes. For more details, please see the release notes.
Notable changes in this release include:
Features:

Add new options like INHERIT and SET to the Role's membership tab.
Add a new button in the query tool data output toolbar to get entire range of data.
Enhance OAUTH2 and OIDC authentication support with improved claims handling and configuration options.

Bugs/Housekeeping:

Mask the secret key for restrict option in the process watcher when restoring plain SQL file (CVE-2026-1707).
Fix Query Tool state restoration for new connections and queries.
Fix pg_restore logs to distinguish UI sync issues from actual failures.
Optimize checkbox selection logic in backup dialog objects tree.
Fixed an issue where double click to open a file in the file manager is not working.
Ensure saved shared server passwords are re-encrypted on password change.
Fixed an issue where the dashboard freezes on initial render when there is a high number of locks.
Fixed the SSL certificate issue while checking for the upgrade.
Fixed a sorting issue in the system stats memory usage table.
Disable Parameters and Membership fields when object is not new for Login and group roles.
Fixed an issue where the Query History panel would auto-scroll to the top and did not preserve the scroll bar position for the selected entry.
Fixed an issue where pgAdmin4 app on macOS cannot auto-update while running on a read-only volume even if present in the Applications folder.
Fixed an issue where connection parameters were using localized values instead of literal values, causing connection failures.
Ensure the container deployment supports boolean values in yaml format.
Fix pgAdmin fails when performing Backup/Restore on a PostgreSQL connection defined exclusively via pg_service.conf.

Download your copy now!

[H2] 2025-12-11 - pgAdmin 4 v9.11 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.11. 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:

Add support of DEPENDS/NO DEPENDS ON EXTENSION for INDEX.
Add support of DEPENDS/NO DEPENDS ON EXTENSION for MATERIALIZED VIEW.
Add support for showing the column data type beside column name in the object explorer.
Added Ubuntu 25.10 and Fedora 43.
Add conditional TLS support for the Ingress in the Helm chart.

Bugs/Housekeeping:

Plain SQL restore runs with '\restrict' option to prevent harmful psql meta-commands (CVE-2025-13780).
Fixed an issue on type casting of default string function/procedure arguments in debugger tool.
Fix pkg_resources deprecation warning by migrating Docker base image to python:3-alpine from alpine:latest.
Fixed an issue where EXPLAIN should run on query under cursor if no text is selected.
Fixed an issue where opening file in Query Tool does not retain file name in tab.
Fixed an issue where connection is failing via Query Tool/PSQL Tool workspaces.

Fixed an issue where copying highlighted text in the query tool data output cell editor would copy the complete string.
Fixed an issue where copying a single cell should not add quoting.
Fix the Helm chart server definition and change the app version.
Specify the correct hostname placeholder for the Password Exec command.
Ensure the proper handling of extra volume mount configurations in the Helm deployment template by correcting the configuration value references.

Download your copy now!

[H2] 2025-11-13 - pgAdmin 4 v9.10 Released
The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.10. This release of pgAdmin 4 includes 5 new features and 12 bug fixes/housekeeping changes. For more details, please see the release notes.
Notable changes in this release include:
Features:

Added the ability to search for tables and automatically bring them into view in the ERD tool.
Add support of DEPENDS/NO DEPENDS ON EXTENSION for PROCEDURE.
Add support for setting image download resolution in the ERD tool.
Add support for displaying detailed Citus query plans instead of 'Custom Scan' placeholder.
Add support for formatting .pgerd ERD project file.

Bugs/Housekeeping:

Fixed an issue where data output column resize is not sticking in Safari.
Fixed an issue where Schema Diff does not ignore Tablespace for indexes.
Fixed an issue where the 2FA window redirected to the login page after session expiration.
Fixed an issue where the Select All option on the columns tab of import/export data was not working in languages other than English.
Fixed an issue where the Debian build process failed with a "Sphinx module not found" error when using a Python virtual environment.
Fixed an issue where the last used storage directory was reset to blank, leading to access denied errors during backup or restore operations.
Fixed an issue that prevented assigning multiple users to an RLS policy.
Fixed remote code execution vulnerability when restoring PLAIN-format SQL dumps in server mode (CVE-2025-12762).
Fixed Command injection vulnerability allowing arbitrary command execution on Windows (CVE-2025-12763).
Fixed LDAP authentication flow vulnerable to TLS certificate verification bypass (CVE-2025-12765).
Fixed LDAP injection vulnerability in LDAP authentication flow (CVE-2025-12764).
Migrate pgAdmin UI to use React 19.

Download your copy now!

[H2] 2025-10-16 - pgAdmin 4 v9.9 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.9. This release of pgAdmin 4 includes 10 bug fixes and new features. For more details, please see the release notes.
Notable changes in this release include:
Features:

Add support of DEPENDS/NO DEPENDS ON EXTENSION for ALTER FUNCTION.
Added "MULTIRANGE_TYPE_NAME" option while creating a Range Type.
Added "SUBSCRIPT" option while creating an External Type.
Added option to skip the password dialog when using an identity file.
Added 'failover' and 'two_phase' parameter support in CREATE/ALTER SUBSCRIPTION for PostgreSQL v17+.
Add support for initializing the pgAdmin4 Kubernetes Helm chart.

Bugs/Housekeeping:

Fixed an issue where the query tool displayed 'default' instead of 'null' for null text data in the data output.
Fixed an issue where the pgAdmin configuration database wasn't being created on a fresh install when an external database was used for the configuration.
Fixed an issue where shortcuts are not working as expected on multiple keyboard layouts.
Fixed an issue where saving the newly changed preferences was not reflecting on the preferences tab.

Download your copy now!

[H2] 2025-09-04 - pgAdmin 4 v9.8 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.8. This release of pgAdmin 4 includes 10 bug fixes and new features. For more details, please see the release notes.
Notable changes in this release include:
Features:

Add menu items for truncating foreign tables.
Added Debian Trixie as a supported platform for pgAdmin.
Allow user to configure security related gunicorn parameters.
Change the default pgAdmin theme to System.

Bugs/Housekeeping:

Fixed Cross-Origin Opener Policy (COOP) vulnerability in the OAuth 2.0 authentication flow (CVE-2025-9636).
Remove usage of BrowserFS as it is deprecated.
Pin Paramiko to version 3.5.1 to fix the DSSKey error introduced in the latest release.
Fixed an issue where pgAdmin config migration was failing while upgrading to v9.7.
Fixed an issue where editor shortcuts fail when using Option key combinations on macOS, due to macOS treating Option+Key as a different key input.
Fixed an issue where the pgAdmin configuration database wasn’t being created on a fresh install when an external database was used for the configuration.

Download your copy now!

[H2] 2025-08-21 - pgAdmin 4 v9.7 Released
The pgAdmin Development Team is pleased to announce the release of pgAdmin 4 version 9.7. This release of pgAdmin 4 includes 22 bug fixes and new features. For more details, please see the release notes.
Notable changes in this release include:
Features:

Add support for automatic updates in the pgAdmin 4 Desktop application on macOS.
Added GENERIC_PLAN, MEMORY, and SERIALIZE options to EXPLAIN/EXPLAIN ANALYZE command.
Add support for changing the cursor blink rate within the editors.
Add support for server tag-based filtering in the Object Explorer.
Added support for builtin locale provider while creating Collation.

Bugs/Housekeeping:

Introduced an ‘Editor’ preferences category and migrated all editor related settings into it.
Fixed an issue where CPU usage was very high on Windows when opening the psql tool.
Fixed an issue where adding breakpoints caused errors, and stepping out of a nested functio

[H1] Blog Posts
Want to see your pgAdmin blog post here? Email webmaster@pgadmin.org.

[H2] 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

[H2] 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

[H2] 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

[H2] Configuring and Using Shared Storage in pgAdmin 4
Author: Nikhil Mohite, date: May 31, 2023
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL. In this blog, I will walk you through how to configure and use shared storage in pgAdmin 4.
Read more

[H2] How to use pgAgent in pgAdmin 4
Author: Pravesh Sharma, date: May 10, 2023
pgAgent is a tool used for scheduling jobs for PostgreSQL databases. Each job consists of steps and schedules.

In this blog we will look at how pgAdmin can be used to create scheduled jobs using pgAgent with PostgreSQL, with steps and schedules to achieve what you want, when you want.
Read more

[H2] Setup pgAdmin development environment
Author: Aditya Toshniwal, date: May 10, 2023
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL. In this blog, I will walk you through how to set up the pgAdmin development environment on your machine. The code repository for pgAdmin 4 is: https://github.com/pgadmin-org/pgadmin4.
Read more

[H2] Google Cloud SQL - PostgreSQL Deployment with pgAdmin 4
Author: Yogesh Mahajan, date: May 2, 2023
pgAdmin 4 has added functionality to deploy cloud instances for PostgreSQL on AWS, Azure and BigAnimal. pgAdmin version 7.0 has introduced the new functionality for deploying a Google Cloud SQL PostgreSQL instance from pgAdmin. To launch a Google Cloud SQL PostgreSQL instance, the prerequisite is to create and download a client secret file containing the client ID, client secret, and other OAuth 2.0 parameters for google authentication. This feature enables you to quickly deploy the PostgreSQL instance to the desired region on Google Cloud, with custom configuration, and connect to it with pgAdmin.
Read more

[H2] pgAgent Setup
Author: Khushboo Vashi, date: March 21, 2023
pgAgent is a job scheduling agent for Postgres databases, capable of running multi-step batch or shell scripts and SQL tasks on complex schedules, which may be managed using pgAdmin.

pgAgent shipped as a separate application. This blog is for users/developers who specifically want to build from a source. Most users should use pre-built packages from the PostgreSQL APT/YUM repositories, or StackBuilder.
Read more

[H2] pgAdmin with Kerberos and Active Directory
Author: Khushboo Vashi, date: March 21, 2023
pgAdmin supports Kerberos authentication for user logins as well as connecting to databases. Kerberos is a popular authentication method but many people find it difficult to set up especially with Windows Active Directory. In this blog, I will walk through the steps to set up Kerberos with pgAdmin and Active Directory.
Read more

[H2] OAuth2 Enhancements in pgAdmin
Author: Khushboo Vashi, date: Feb. 3, 2023
pgAdmin supports multiple authentication methods including OAuth2 for login into the app in web mode. We have added support for OAuth2 in July 2021. After that, the development team enhanced the OAuth2 functionality.
Read more

[H2] Create an ERD in pgAdmin 4
Author: Aditya Toshniwal, date: Feb. 1, 2023
The Entity-Relationship Diagram (ERD) tool is a database design tool that provides a graphical representation of database tables, columns, and inter-relationships. An ERD can give sufficient information for the database administrator to follow when developing and maintaining the database.
Read more

[H2] How to setup Two Factor Authentication in pgAdmin 4
Author: Akshay Joshi, date: Dec. 7, 2022
Two-Factor Authentication (2FA) works by adding an additional layer of security to your online accounts. It requires an additional login credential - something you have - to gain account access, in addition to your password (something you know).

This feature is only available in Server Mode.
pgAdmin 4 supports two types of 2FA:

Email Authentication
Authenticator App (e.g: Google Authenticator)
Read more

[H2] Psycopg2 to Psycopg3 migration in pgAdmin 4
Author: Khushboo Vashi, date: Dec. 7, 2022
Recently the Psycopg project released a major version, Psycopg3. pgAdmin 4 is immensely dependent on psycopg2 as it is being used as a database driver and the pgAdmin team decided to migrate to the new latest version.
Initially, we thought that it would be hardly 3 to 4 weeks work as it is just a migration but our assumption was incorrect. The reason is we haven’t used psycopg2 "out of the box", we have extended many things and one of them is cursor factory. So, when I started porting, I realized the way we have done that is not supported any more, so I have started digging into the code and found out that in the next release, that was supposed to be included. So, I cloned the repo, built it on my local and used it till 3.1 official release.
Psycopg3 is completely rewritten, so it’s a vast topic to cover, but we will look at some of the areas which affected pgAdmin.
Read more

[H2] How to use an external database for pgAdmin user settings
Author: Akshay Joshi, date: Nov. 18, 2022
The purpose of this blog is to illustrate how to save pgAdmin 4 configurations to an external database server. In addition, we covered examples that demonstrate how to use PostgreSQL server as an external database.
Read more

[H2] pgAdmin config files
Author: Pravesh Sharma, date: Nov. 14, 2022
This blog explains the purpose of the various configuration files used by pgAdmin, when they should be modified, and for what reason.
Read more

[H2] Import Export Servers in pgAdmin 4
Author: Akshay Joshi, date: Sept. 2, 2022
In this blog we look at how server definitions can be imported and exported from pgAdmin using the command line or the graphical user interface. This allows server definitions to be migrated between pgAdmin installations and shared with colleagues.
Read more

[H2] EDB BigAnimal Deployment through pgAdmin 4
Author: Khushboo Vashi, date: Sept. 2, 2022
In this blog we demonstrate how to deploy PostgreSQL or EDB Advanced Server in the EDB BigAnimal Cloud using pgAdmin.
Read more

[H2] AWS RDS PostgreSQL Deployment with pgAdmin 4
Author: Yogesh Mahajan, date: Aug. 17, 2022
This blog explains and provides a walkthrough of the pgAdmin AWS RDS deployment wizard which can be used to deploy a new PostgreSQL database in the Amazon AWS cloud and register it with pgAdmin so you can begin working with it immediately.
Read more

[H2] pgAdmin User Survey 2022
Author: Dave Page, date: Aug. 2, 2022
On Monday 11th July the pgAdmin Development Team opened the first pgAdmin user survey which we then ran for three weeks, closing it on Monday 1st August. The aim of the survey was to help us understand how users are using pgAdmin to help us shape and focus our future development efforts.

We had a fantastic response with 278 people taking the time to complete the survey - far exceeding our expectations. Responses were generally positive as well, with a number of people expressing their appreciation for the work of the development team, which is always nice to hear.

In this blog post I'll go through the high level topics of the survey and attempt to summarise what has been reported, and draw some initial conclusions. If you would like to take a look at the results yourself...
Read more

[H2] Autocomplete feature in Query Tool
Author: Akshay Joshi, date: June 10, 2022
To use autocomplete, begin typing your query; when you would like the query editor to suggest object names or commands that might be next in your query, press the Control + Space key combination. For example, type "SELECT * FROM " (without quotes, but with a trailing space), and then press the Control + Space key combination to select from a popup menu of autocomplete options.
Read more

[H2] pgAdmin 4 Architecture
Author: Yogesh Mahajan, date: May 27, 2022
pgAdmin 4 is the leading Open Source management tool for Postgres. pgAdmin is designed to monitor and manage multiple PostgreSQL and EDB Advanced Server database servers, both local and remote, through a single graphical interface that allows the easy creation and management of database objects, as well as a number of other tools for managing your databases.

pgAdmin can be installed in two modes: Desktop & Server mode. Desktop mode is installed as a standalone application being used by the same operating system user while server mode can be accessed over the network, allowing it to be used by multiple users.

Both mode implementations follow a 3 tier architecture approach. This blog explains the pgAdmin architecture and technologies used in both modes.
Read more

[H2] Query Tool vs View/Edit Data
Author: Nikhil Mohite, date: May 10, 2022
Ever wondered what the differences are between the Query Tool and View/Edit Data tool in pgAdmin? In this blog Nikhil explains those differences and when each tool should be used.
Read more

[H2] How to Configure OAuth 2.0 with Azure AD in pgAdmin4
Author: Asmita Thapliyal, date: April 29, 2022
pgAdmin user Asmita Thapliyal writes:

I struggled for few days to get OAuth 2.0 configuration works for Azure AD in pgAdmin4, which leads me to writing this blog post.

We were looking for a hosted web interface for running SELECT queries in AWS Aurora database from on premise environment. This interface would allow developers for database interaction and to perform initial troubleshooting without sharing the database credentials and whitelisting the connection from their laptops and vms.
Read more

[H2] Use of the Master Password in pgAdmin 4
Author: Akshay Joshi, date: April 22, 2022
pgAdmin 4 introduced the Master Password in order to secure and later unlock saved server passwords. Any password that is saved in the SQLite DB file - used for storing user preferences and other data - through the save password or save SSH tunnel password option will be encrypted and decrypted using the master password.

The feature was introduced in pgAdmin 4 version 4.7 and above. This is applicable to Desktop mode users as well as to authentication methods like OAuth, Kerberos, or Web Server where pgAdmin doesn’t have access to anything long-lived to form the encryption key whereas with pgAdmin internal or LDAP authentication methods, the user’s login password is used as an encryption key.
Read more

[H2] pgAdmin 4 Browser Tree
Author: Khushboo Vashi, date: April 6, 2022
This blog from pgAdmin developer Khushboo Vashi discusses the technical changes made to the rendering of the treeview in pgAdmin.
Read more

[H2] Feature Test Automation in pgAdmin 4
Author: Yogesh Mahajan, date: Feb. 23, 2022
pgAdmin follows an Agile development process with an iterative and incremental approach to development. Testing is a critical part of the development process. pgAdmin is regularly tested with a subset of the available versions, ensuring a high-quality product. The test suite includes API testing, UI Testing (referred as Feature Testing), unit testing, and "resql" testing, a pgAdmin-specific test framework for testing the reverse engineering of SQL.
To achieve better quality in the short release cycles, test automation is required. The Selenium WebDriver with Python is used for feature test automation. Feature test frameworks currently support parallel testing/cross-browser testing. The new era of continuous testing requires faster test execution. Parallel testing involves running independent tests in parallel to reduce overall test execution time by allowing multiple OS/browser combinations to be tested simultaneously. An extended test coverage minimizes risk and reduces the chances of releasing a product with regressions or defects.
Read more

[H2] Dashboards in pgAdmin 4
Author: Nikhil Mohite, date: Feb. 3, 2022
The dashboard tab in pgAdmin shows an analysis of the activity statistics for the selected server or database.

It also shows quick links to Add New Server, Configure pgAdmin, and Documentation if a Server Group node is selected from the browser tree.
Read more

[H2] SSH Tunneling in pgAdmin 4
Author: Rahul Shirsat, date: Jan. 6, 2022
SSH tunneling is a method of transporting arbitrary networking data over an encrypted SSH connection. It can be used to add encryption to legacy applications or implement VPNs (Virtual Private Networks). It is a way to secure the data traffic of any given application using port forwarding, basically tunneling any TCP/IP port over SSH.

pgAdmin 4 supports SSH Tunneling, i.e. it - through an intermediary proxy host - can be connected to a PostgreSQL server that resides on a network to which the client may not be able to connect directly.

This blog will guide you to setup SSH tunneling with pgAdmin 4.
Read more

[H2] Shared Servers in pgAdmin 4
Author: Pradip Parkale, date: Jan. 4, 2022
Shared servers allow the admin user to share servers with other users so that they can use them directly without adding them themselves.
Shared servers only apply when pgAdmin is running in server mode. Server mode is a multi-user mode whereas Desktop mode is single user mode. In server mode users must login before they can use pgAdmin. An initial superuser account is created when server mode is initialised, and this user can add additional superusers and non-