CVE-2026-61781
pg_partman has privilege escalation through SQL injection in create_partition_time()
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, create_partition_time() reads the writable part_config.time_encoder text value and interpolates it without identifier quoting into a dynamically executed SELECT statement. A role with the documented partman_user INSERT and UPDATE privileges can store SQL rather than a function name. When pg_partman_bgw later creates a child partition for a text- or UUID-keyed set, the worker executes the stored SQL with pg_partman_bgw.role privileges, which default to PostgreSQL superuser. The persistent configuration row can repeatedly restore elevated access on later maintenance ticks, and successful exploitation can permit database-wide compromise and operating-system command execution as the PostgreSQL service account. This issue is fixed in version 5.5.0.
Attack profile
How easy it is to exploit
- Attack vector
- Network
- Complexity
- Low
- Privileges needed
- Low
- User interaction
- None
What an attacker can affect
- Confidentiality
- High
- Integrity
- High
- Availability
- High
Exploit likelihood
What each source reports
CVE List Score used
9.9
pg_partman has privilege escalation through SQL injection in create_partition_time()
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, create_partition_time() reads the writable part_config.time_encoder text value and interpolates it without identifier quoting into a dynamically executed SELECT statement. A role with the documented partman_user INSERT and UPDATE privileges can store SQL rather than a function name. When pg_partman_bgw later creates a child partition for a text- or UUID-keyed set, the worker executes the stored SQL with pg_partman_bgw.role privileges, which default to PostgreSQL superuser. The persistent configuration row can repeatedly restore elevated access on later maintenance ticks, and successful exploitation can permit database-wide compromise and operating-system command execution as the PostgreSQL service account. This issue is fixed in version 5.5.0.
- Record
CVE-2026-61781- CVSS 3.1
- 9.9 Critical
CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H - Weakness
- CWE-89, CWE-269
- Updated
- 2026-11-02
EUVDEUVD-2026-83418
9.9
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, create_partition_time() reads the writable part_config.time_encoder text value and interpolates it without identifier quoting into a dynamically executed SELECT statement. A role with the documented partman_user INSERT and UPDATE privileges can store SQL rather than a function name. When pg_partman_bgw later creates a child partition for a text- or UUID-keyed set, the worker executes the stored SQL with pg_partman_bgw.role privileges, which default to PostgreSQL superuser. The persistent configuration row can repeatedly restore elevated access on later maintenance ticks, and successful exploitation can permit database-wide compromise and operating-system command execution as the PostgreSQL service account. This issue is fixed in version 5.5.0.
- Record
EUVD-2026-83418- CVSS 3.1
- 9.9 Critical
CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H - Updated
- 2026-11-02
NVD
9.9
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, create_partition_time() reads the writable part_config.time_encoder text value and interpolates it without identifier quoting into a dynamically executed SELECT statement. A role with the documented partman_user INSERT and UPDATE privileges can store SQL rather than a function name. When pg_partman_bgw later creates a child partition for a text- or UUID-keyed set, the worker executes the stored SQL with pg_partman_bgw.role privileges, which default to PostgreSQL superuser. The persistent configuration row can repeatedly restore elevated access on later maintenance ticks, and successful exploitation can permit database-wide compromise and operating-system command execution as the PostgreSQL service account. This issue is fixed in version 5.5.0.
- Record
CVE-2026-61781- CVSS 3.1
- 9.9 Critical
CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H - Weakness
- CWE-89, CWE-269
- Updated
- 2026-11-02
OSV
9.9
pg_partman has privilege escalation through SQL injection in create_partition_time()
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, create_partition_time() reads the writable part_config.time_encoder text value and interpolates it without identifier quoting into a dynamically executed SELECT statement. A role with the documented partman_user INSERT and UPDATE privileges can store SQL rather than a function name. When pg_partman_bgw later creates a child partition for a text- or UUID-keyed set, the worker executes the stored SQL with pg_partman_bgw.role privileges, which default to PostgreSQL superuser. The persistent configuration row can repeatedly restore elevated access on later maintenance ticks, and successful exploitation can permit database-wide compromise and operating-system command execution as the PostgreSQL service account. This issue is fixed in version 5.5.0.
- Record
CVE-2026-61781- CVSS 3.1
- 9.9 Critical
CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H - Weakness
- CWE-269, CWE-89
- Updated
- 2026-11-02
OSVDEBIAN-CVE-2026-61781
9.9
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, create_partition_time() reads the writable part_config.time_encoder text value and interpolates it without identifier quoting into a dynamically executed SELECT statement. A role with the documented partman_user INSERT and UPDATE privileges can store SQL rather than a function name. When pg_partman_bgw later creates a child partition for a text- or UUID-keyed set, the worker executes the stored SQL with pg_partman_bgw.role privileges, which default to PostgreSQL superuser. The persistent configuration row can repeatedly restore elevated access on later maintenance ticks, and successful exploitation can permit database-wide compromise and operating-system command execution as the PostgreSQL service account. This issue is fixed in version 5.5.0.
- Record
DEBIAN-CVE-2026-61781- CVSS 3.1
- 9.9 Critical
CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H - Updated
- 2026-11-02
OSVUBUNTU-CVE-2026-61781
9.9
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, create_partition_time() reads the writable part_config.time_encoder text value and interpolates it without identifier quoting into a dynamically executed SELECT statement. A role with the documented partman_user INSERT and UPDATE privileges can store SQL rather than a function name. When pg_partman_bgw later creates a child partition for a text- or UUID-keyed set, the worker executes the stored SQL with pg_partman_bgw.role privileges, which default to PostgreSQL superuser. The persistent configuration row can repeatedly restore elevated access on later maintenance ticks, and successful exploitation can permit database-wide compromise and operating-system command execution as the PostgreSQL service account. This issue is fixed in version 5.5.0.
- Record
UBUNTU-CVE-2026-61781- CVSS 3.1
- 9.9 Critical
CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H - Updated
- 2026-11-02
Affected products
Affected packages
| Package | Affected | Fixed |
|---|---|---|
pg-partmanDebian:12 |
All versions, plus listed versions 4.7.2-14.7.3-14.7.4-25.0.0-15.0.0-2 Show 16 moreShow less5.0.1-15.1.0-15.1.0-25.2.0-15.2.1-15.2.2-15.2.4-15.3.0-15.3.0~rc1-15.3.1-15.3.1-25.4.0-15.4.1-15.4.2-15.4.3-15.5.0-1 |
None known |
pg-partmanDebian:13 |
All versions, plus listed versions 5.2.4-15.3.0-15.3.0~rc1-15.3.1-15.3.1-2 Show 5 moreShow less5.4.0-15.4.1-15.4.2-15.4.3-15.5.0-1 |
None known |
pg-partmanDebian:14 |
before 5.5.0-1, plus listed versions 5.2.4-15.3.0-15.3.0~rc1-15.3.1-15.3.1-2 Show 4 moreShow less5.4.0-15.4.1-15.4.2-15.4.3-1 |
5.5.0-1 |
pg-partmanUbuntu:16.04:LTS |
All versions, plus listed versions 2.2.2-12.2.2-2 |
None known |
pg-partmanUbuntu:18.04:LTS |
All versions, plus listed versions 2.6.3-13.1.0-13.1.1-13.1.2-1 |
None known |
pg-partmanUbuntu:20.04:LTS |
All versions, plus listed versions 4.0.0-14.2.0-14.2.2-14.3.0-1 |
None known |
pg-partmanUbuntu:22.04:LTS |
All versions, plus listed versions 4.5.1-14.6.0-1 |
None known |
pg-partmanUbuntu:24.04:LTS |
All versions, plus listed versions 4.7.3-15.0.0-25.0.1-1 |
None known |
pg-partmanUbuntu:26.04:LTS |
All versions, plus listed versions 5.2.4-15.3.1-25.4.0-15.4.1-1 |
None known |
History
| Recorded | Changed | Sources |
|---|---|---|
| first indexed | CVE List, EUVD, NVD, OSV |
Dates are when Every CVE recorded each change. Upstream dates may differ.
In short
CVE-2026-61781 is a critical vulnerability (CVSS 9.9) in Pgpartman Pg Partman, published September 18, 2026. No source lists public exploit code. EPSS puts the chance of exploitation in the next 30 days at 0.80%, the 56th percentile. Fixed in pg-partman 5.5.0-1.
References
github.com/pgpartman/pg_partman/security/advisories/GHSA-742w-3j7c-qwvp
github.com/pgpartman/pg_partman/commit/ba9405542acf24dd881845b935cab8b165854361
github.com/pgpartman/pg_partman/releases/tag/v5.5.0
github.com/CVEProject/cvelistV5/tree/main/cves/2026/61xxx/CVE-2026-61781.json
nvd.nist.gov/vuln/detail/CVE-2026-61781
security-tracker.debian.org/tracker/CVE-2026-61781
ubuntu.com/security/CVE-2026-61781
cve.org/CVERecord?id=CVE-2026-61781