The pgAdmin 4 graphical management panel has held the title of the go-to tool for working with PostgreSQL databases for decades. However, in Server Mode—when pgAdmin is deployed as a web portal inside a corporate network for hundreds of analysts and engineers—the application inevitably becomes a prime target for attackers. Direct access to DBMS network ports and high system privileges demand uncompromising security.
The project's development team has shipped a major release, pgAdmin 4 v9.19, detailed in the pgAdmin 4 v9.19 release notes. The update packs 136 fixes and closes 15 dangerous security vulnerabilities across the range CVE-2026-116238 to CVE-2026-116252.
Comprehensive Vulnerability Remediation (15 CVEs)
The centerpiece flaw fixed in this release is the critical CVE-2026-116241. The bug hid in the Import/Export Data module: by crafting quotes and special characters, an attacker could bypass the parentheses check on the \copy directive and inject a malicious TO PROGRAM clause. That made it possible to execute arbitrary operating system commands remotely on the host running pgAdmin.
Alongside it, developers closed a series of systemic flaws:
CVE-2026-116239: fixed account spoofing during external authentication via LDAP and Kerberos, where users with matching names mistakenly gained access to other people's profiles (including the superadmin account);CVE-2026-116238: eliminated a bypass of failed login and password-reset rate limits in the built-in Flask-Security forms;CVE-2026-116246: stopped database passwords from leaking into child-process environment variables;CVE-2026-116250: closed TOCTOU (Time-of-Check to Time-of-Use) race conditions during operations with symlinks and FIFO pipes in the file manager.
Administrators of multi-user installations should note a key change: the config_local.py configuration file introduces the SERVER_PASSEXEC_COMMANDS parameter. Arbitrary shell commands for automatic password retrieval are now forbidden: scripts must be listed on a strict allowlist and run in an isolated environment without a system shell.
Extended Statistics and Functional Improvements
Alongside the security hardening, version 9.19 brings analysts and DBAs a long-awaited feature. A full Extended Statistics node has arrived in the database object tree.
PostgreSQL's query planner relies on column statistics, yet for complex filter predicates across multiple correlated columns, standard single-column histograms fall short. Engineers can now visually configure multi-column statistics collection:
- Number of distinct column-pair combinations (
ndistinct); - Functional dependencies between columns (
dependencies); - Most-common value combinations (
mcv).
Other welcome additions include direct row editing in the View/Edit Data grid via simple auto-updatable views, exporting query results to JSON and XML with encoding and BOM flag control, and built-in integration with the popular background job scheduler pg_timetable.
Release 9.19 is a mandatory upgrade for all corporate PostgreSQL administration servers.
