Skip to content
Heist/ feed
Back to feed
Critical

pg_partman has privilege escalation through SQL injection in create_partition_time()

Type: advisorySources: OSV

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.

Products
Not specified
Affected versions
Not specified
Fixed versions
Not specified
CVEs
CVE-2026-61781
Confirmed fixed CVEs
Not specified
Updated in this feed
4 Nov 2026, 03:30 UTC · Revision 1

Source evidence

pg_partman has privilege escalation through SQL injection in create_partition_time()

core-osv · Original source

Published 18 Sept 2026, 19:44 UTC

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.

osv:CVE-2026-61781
Complete source record
{
  "id": "424b40c92d1eb02c6fbd5d4bee18fcf839b9fdf4de127c28ca529c2cf27097f7",
  "url": "https://osv.dev/vulnerability/CVE-2026-61781",
  "method": "structured",
  "payload": {
    "kind": "advisory",
    "title": "pg_partman has privilege escalation through SQL injection in create_partition_time()",
    "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 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.",
    "evidence": "osv:CVE-2026-61781",
    "products": [],
    "severity": "critical",
    "structured": {
      "id": "CVE-2026-61781",
      "aliases": [
        "CVE-2026-61781",
        "GHSA-742w-3j7c-qwvp"
      ],
      "metrics": [
        {
          "type": "CVSS_V3",
          "score": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:C/C:H/I:H/A:H"
        }
      ],
      "affected": [
        {
          "ranges": [
            {
              "repo": "https://github.com/pgpartman/pg_partman",
              "type": "GIT",
              "events": [
                {
                  "introduced": "0"
                },
                {
                  "fixed": "f7e83b9c441c7e97066d815bbe14e02a9dc5ff94"
                },
                {
                  "fixed": "ba9405542acf24dd881845b935cab8b165854361"
                }
              ],
              "database_specific": {
                "extracted_events": [
                  {
                    "range": [
                      {
                        "introduced": "0"
                      },
                      {
                        "fixed": "5.5.0"
                      }
                    ],
                    "source": "AFFECTED_FIELD",
                    "strategy": "StringRangeExpression"
                  },
                  {
                    "range": [
                      {
                        "fixed": "ba9405542acf24dd881845b935cab8b165854361"
                      }
                    ],
                    "source": "REFERENCES_COMMIT"
                  },
                  {
                    "range": [
                      {
                        "fixed": "f7e83b9c441c7e97066d815bbe14e02a9dc5ff94"
                      }
                    ],
                    "source": "REFERENCES_TAG",
                    "original_tag": "v5.5.0"
                  }
                ]
              }
            }
          ],
          "versions": [
            "v5.4.3",
            "v5.4.2",
            "v5.4.1",
            "v5.4.0",
            "v5.3.1",
            "v5.3.0",
            "v5.3.0RC1",
            "v5.2.4",
            "v5.2.3",
            "v5.2.2",
            "v5.2.1",
            "v5.2.0",
            "v5.1.0",
            "v5.0.1",
            "v5.0.0",
            "v4.7.1",
            "v4.7.0",
            "v4.6.2",
            "v4.6.1",
            "v4.6.0",
            "v4.5.1",
            "v4.5.0",
            "v4.4.1",
            "v4.4.0",
            "v4.3.1",
            "v4.3.0",
            "v4.2.2",
            "v4.2.1",
            "v4.2.0",
            "v4.1.0",
            "v4.0.0",
            "v3.2.1",
            "v3.2.0",
            "v3.1.3",
            "v3.1.2",
            "v3.1.1",
            "v3.1.0",
            "v3.0.2",
            "v3.0.1",
            "v2.6.4",
            "v2.6.3",
            "v2.6.2",
            "v2.6.1",
            "v2.6.0",
            "v2.5.1",
            "v2.5.0",
            "v2.4.1",
            "v2.4.0",
            "v2.3.4",
            "v2.3.3",
            "v2.3.2",
            "v2.3.1",
            "v2.3.0",
            "v2.2.3",
            "v2.2.2",
            "v2.2.1",
            "v2.2.0",
            "v2.1.0",
            "v2.0.0",
            "v1.8.7",
            "v1.8.6",
            "v1.8.5",
            "v1.8.4",
            "v1.8.3",
            "v1.8.2",
            "v1.8.1",
            "v1.8.0",
            "v1.7.2",
            "v1.7.1",
            "v1.7.0",
            "v1.6.1",
            "v1.6.0",
            "v1.5.1",
            "v1.5.0",
            "v1.4.5",
            "v1.4.4",
            "v1.4.3",
            "v1.4.1",
            "v1.4.0",
            "v1.3.0",
            "v1.2.0",
            "v1.1.0",
            "v1.0.0",
            "v0.4.2",
            "v0.4.1",
            "v0.4.0",
            "v0.3.2",
            "v0.3.1",
            "v0.3.0",
            "v0.2.0",
            "v0.1.2",
            "v0.1.1"
          ],
          "database_specific": {
            "source": "https://storage.googleapis.com/cve-osv-conversion/osv-output/CVE-2026-61781.json"
          }
        }
      ],
      "modified": "2026-10-28T02:30:32.727490650Z",
      "provider": "osv",
      "references": [
        "https://github.com/pgpartman/pg_partman/releases/tag/v5.5.0",
        "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/61xxx/CVE-2026-61781.json",
        "https://github.com/pgpartman/pg_partman/security/advisories/GHSA-742w-3j7c-qwvp",
        "https://nvd.nist.gov/vuln/detail/CVE-2026-61781",
        "https://github.com/pgpartman/pg_partman/commit/ba9405542acf24dd881845b935cab8b165854361"
      ],
      "provider_metadata": {
        "cwe_ids": [
          "CWE-269",
          "CWE-89"
        ],
        "cna_assigner": "GitHub_M",
        "osv_generated_from": "https://github.com/CVEProject/cvelistV5/tree/main/cves/2026/61xxx/CVE-2026-61781.json"
      }
    },
    "related_cves": [
      {
        "value": "CVE-2026-61781",
        "evidence": "/id"
      }
    ],
    "security_relevant": true,
    "severity_evidence": "/severity/0/score"
  },
  "source_id": "core-osv",
  "document_id": 500033,
  "published_at": "2026-09-18T19:44:21.808+00:00"
}