{"id":"CVE-2026-61781","aliases":["DEBIAN-CVE-2026-61781","EUVD-2026-83418","GHSA-742w-3j7c-qwvp","UBUNTU-CVE-2026-61781"],"status":"published","title":"pg_partman has privilege escalation through SQL injection in create_partition_time()","description":"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.","severity":{"version":"3.1","score":9.9,"vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H","level":"critical","assessor":"cna","from":"cve"},"epss":{"day":"2026-11-11","score":0.00804,"percentile":0.57173,"model":"v2026.06.15"},"facts":{"in_kev":false,"known_exploited":false,"public_exploit":false,"fix_available":true},"cwes":["CWE-269","CWE-89"],"published":"2026-09-18T19:44:21Z","modified":"2026-10-28T02:30:32Z","fixes":[{"ecosystem":"Debian:14","package":"pg-partman","fixed_in":["5.5.0-1"],"sources":["osv"]}],"affected":[{"source":"osv","ecosystem":"Debian:12","package":"pg-partman","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["4.7.2-1","4.7.3-1","4.7.4-2","5.0.0-1","5.0.0-2","5.0.1-1","5.1.0-1","5.1.0-2","5.2.0-1","5.2.1-1","5.2.2-1","5.2.4-1","5.3.0-1","5.3.0~rc1-1","5.3.1-1","5.3.1-2","5.4.0-1","5.4.1-1","5.4.2-1","5.4.3-1","5.5.0-1"]},{"source":"osv","ecosystem":"Debian:13","package":"pg-partman","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["5.2.4-1","5.3.0-1","5.3.0~rc1-1","5.3.1-1","5.3.1-2","5.4.0-1","5.4.1-1","5.4.2-1","5.4.3-1","5.5.0-1"]},{"source":"osv","ecosystem":"Debian:14","package":"pg-partman","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"5.5.0-1"}]}],"versions":["5.2.4-1","5.3.0-1","5.3.0~rc1-1","5.3.1-1","5.3.1-2","5.4.0-1","5.4.1-1","5.4.2-1","5.4.3-1"]},{"source":"osv","ecosystem":"Ubuntu:16.04:LTS","package":"pg-partman","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["2.2.2-1","2.2.2-2"]},{"source":"osv","ecosystem":"Ubuntu:18.04:LTS","package":"pg-partman","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["2.6.3-1","3.1.0-1","3.1.1-1","3.1.2-1"]},{"source":"osv","ecosystem":"Ubuntu:20.04:LTS","package":"pg-partman","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["4.0.0-1","4.2.0-1","4.2.2-1","4.3.0-1"]},{"source":"osv","ecosystem":"Ubuntu:22.04:LTS","package":"pg-partman","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["4.5.1-1","4.6.0-1"]},{"source":"osv","ecosystem":"Ubuntu:24.04:LTS","package":"pg-partman","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["4.7.3-1","5.0.0-2","5.0.1-1"]},{"source":"osv","ecosystem":"Ubuntu:26.04:LTS","package":"pg-partman","ranges":[{"type":"ECOSYSTEM","events":[{"introduced":"0"}]}],"versions":["5.2.4-1","5.3.1-2","5.4.0-1","5.4.1-1"]}],"products":[{"vendor":"pgpartman","product":"pg_partman"}],"references":[{"url":"https://github.com/pgpartman/pg_partman/security/advisories/GHSA-742w-3j7c-qwvp","tags":["x_refsource_CONFIRM","advisory","report"]},{"url":"https://github.com/pgpartman/pg_partman/commit/ba9405542acf24dd881845b935cab8b165854361","tags":["x_refsource_MISC","fix","report"]},{"url":"https://github.com/pgpartman/pg_partman/releases/tag/v5.5.0","tags":["x_refsource_MISC","web","report"]},{"url":"https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/61xxx/CVE-2026-61781.json","tags":["advisory"]},{"url":"https://nvd.nist.gov/vuln/detail/CVE-2026-61781","tags":["advisory"]},{"url":"https://security-tracker.debian.org/tracker/CVE-2026-61781","tags":["advisory"]},{"url":"https://ubuntu.com/security/CVE-2026-61781","tags":["report"]},{"url":"https://www.cve.org/CVERecord?id=CVE-2026-61781","tags":["report"]}],"sources":{"cve":[{"id":"CVE-2026-61781","title":"pg_partman has privilege escalation through SQL injection in create_partition_time()","description":"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.","status":"published","published":"2026-09-18T19:44:21.808Z","modified":"2026-09-18T20:16:17.069Z","cvss":[{"version":"3.1","score":9.9,"vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H","level":"critical","assessor":"cna"}],"cwes":["CWE-89","CWE-269"],"updated_at":"2026-11-02T14:19:53.4444Z"}],"euvd":[{"id":"EUVD-2026-83418","description":"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.","status":"published","published":"2026-09-18T19:44:21Z","modified":"2026-09-18T20:16:17Z","cvss":[{"version":"3.1","score":9.9,"vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H","level":"critical"}],"updated_at":"2026-11-02T17:28:06.992666Z"}],"nvd":[{"id":"CVE-2026-61781","description":"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.","status":"published","published":"2026-09-18T20:17:19.003Z","modified":"2026-09-23T18:12:04.247Z","cvss":[{"version":"3.1","score":9.9,"vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H","level":"critical","assessor":"secondary"}],"cwes":["CWE-89","CWE-269"],"updated_at":"2026-11-02T14:12:50.043898Z"}],"osv":[{"id":"CVE-2026-61781","title":"pg_partman has privilege escalation through SQL injection in create_partition_time()","description":"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.","status":"published","published":"2026-09-18T19:44:21.808Z","modified":"2026-10-28T02:30:32.72749065Z","cvss":[{"version":"3.1","score":9.9,"vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H","level":"critical"}],"cwes":["CWE-269","CWE-89"],"updated_at":"2026-11-02T15:45:12.933503Z"},{"id":"DEBIAN-CVE-2026-61781","description":"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.","status":"published","published":"2026-09-18T20:17:19.003Z","modified":"2026-09-24T08:47:29.377813403Z","cvss":[{"version":"3.1","score":9.9,"vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H","level":"critical"}],"updated_at":"2026-11-02T15:45:57.932517Z"},{"id":"UBUNTU-CVE-2026-61781","description":"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.","status":"published","published":"2026-09-18T20:17:00Z","modified":"2026-09-23T23:31:26Z","cvss":[{"version":"3.1","score":9.9,"vector":"CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H","level":"critical"}],"updated_at":"2026-11-02T16:56:43.630667Z"}]}}