---
id: CVE-2026-61781
title: >-
  pg_partman is a PostgreSQL extension that manages partitioned tables by time
  or ID
summary: >-
  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 dyna…
severity: critical
cvss: 9.9
cvssVector: 'CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H'
cwe:
  - CWE-89
  - CWE-269
vendor: pgpartman
product: pg_partman
affected:
  - pg_partman < 5.5.0
published: '2026-09-18'
updated: '2026-09-23'
sourceUpdated: '2026-09-23T18:12:04.247'
source: NVD
sourceUrl: 'https://nvd.nist.gov/vuln/detail/CVE-2026-61781'
references:
  - url: >-
      https://github.com/pgpartman/pg_partman/commit/ba9405542acf24dd881845b935cab8b165854361
    label: security-advisories@github.com
  - url: 'https://github.com/pgpartman/pg_partman/releases/tag/v5.5.0'
    label: security-advisories@github.com
  - url: >-
      https://github.com/pgpartman/pg_partman/security/advisories/GHSA-742w-3j7c-qwvp
    label: security-advisories@github.com
  - url: >-
      https://security.access.redhat.com/data/csaf/v2/vex/2026/cve-2026-61781.json
  - url: 'https://access.redhat.com/security/cve/CVE-2026-61781'
  - url: 'https://www.cve.org/CVERecord?id=CVE-2026-61781'
tags:
  - nvd
  - cve.org
  - csaf
  - vex
  - red-hat
epss: 0.00804
epssPercentile: 0.54888
ssvc:
  exploitation: none
  automatable: 'no'
  technicalImpact: total
  timestamp: '2026-09-18T20:16:05.846661Z'
ingestedAt: '2026-09-18T19:49:30.584Z'
---

## Overview

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.

## Remediation

Refer to the linked advisories for vendor-supplied fixes and affected version ranges.

## Vendor advisories

- **Red Hat VEX** · updated 2026-09-24 · [vex](https://security.access.redhat.com/data/csaf/v2/vex/2026/cve-2026-61781.json)
