pgAdmin 4 v9.19: Patching 15 Security Vulnerabilities and Managing Extended StatisticsNote · digest for November 1
Symbolic still life of a secured database server with a code shield and an extended analytics tree
Note2 sections≈ 2 min

pgAdmin 4 v9.19: Patching 15 Security Vulnerabilities and Managing Extended Statistics

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.

Want a deep diveVotes help us choose what to break down in detail. This material has 0 votes.
Sources · 2