Goal Reached Thanks to every supporter — we hit 100%!

Goal: 1000 CNY · Raised: 1336 CNY

100%

CVE-2026-61820— pg_partman privilege escalation via SQL injection when inheriting template properties

Quick assessment

Affected
pgpartman pg_partman
Exploitation
No confirmed in-the-wild exploitation; assess based on exposure
Recommended action
Check the vendor advisory and references for a fixed version. If immediate upgrade is impossible, restrict exposure and increase monitoring.

pg_partman 是一个 PostgreSQL 扩展,用于按时间或 ID 管理分区表。在 5.5.0 版本之前, 函数手动用双引号包裹从 获取的主键列名,但未对嵌入的双引号字符进行转义处理。拥有模板表的 可以创建一个特制的列名,从而在后台工作进程(background worker)将主键应用到子分区时,突破生成的 语句中的标识符边界。由此生成的 SQL 语句将以 的权限执行,而该角色默认具有 PostgreSQL 超级用户权限,从而导致整个数据库被破坏,并允许以 PostgreSQL 服务账户身份执行操作系统

CVSS 8.5 · High

Possible ATT&CK Techniques 1 AI

T1190 · Exploit Public-Facing Application

Affected Version Matrix 1

VendorProduct Version RangeStatus
pgpartman pg_partman < 5.5.0 affected
Get alerts for future matching vulnerabilities Log in to subscribe

I. Basic Information for CVE-2026-61820

Vulnerability Information

Have questions about the vulnerability? See if Shenlong's analysis helps!
View Shenlong Deep Dive ↗

Although we use advanced large model technology, its output may still contain inaccurate or outdated information.Shenlong tries to ensure data accuracy, but please verify and judge based on the actual situation.

Vulnerability Title
pg_partman privilege escalation via SQL injection when inheriting template properties
Source: CVE Program / CVE List V5
Vulnerability Description
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, inherit_template_properties() manually surrounds primary-key column names from pg_attribute.attname with double quotes without escaping embedded double-quote characters. A partman_user who owns a template table can create a crafted column name that breaks out of the generated ALTER TABLE ADD PRIMARY KEY identifier when the background worker applies the key to a child partition. The generated SQL then executes with pg_partman_bgw.role privileges, which default to PostgreSQL superuser, permitting database-wide compromise and operating-system command execution as the PostgreSQL service account. The crafted catalog identifier persists until removed and can trigger again during later partition creation. This issue is fixed in version 5.5.0.
Source: CVE Program / CVE List V5
CVSS Information
CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:C/C:H/I:H/A:H
Source: CVE Program / CVE List V5
Vulnerability Type
SQL命令中使用的特殊元素转义处理不恰当(SQL注入)
Source: CVE Program / CVE List V5

Affected Products

Vendor Product Affected Versions CPE Subscribe
pgpartman pg_partman < 5.5.0 -

II. Public POCs for CVE-2026-61820

# POC Description Source Link Shenlong Link
AI-Generated POC Premium

No public POC found.

Login to generate AI POC

III. Intelligence Information for CVE-2026-61820

登录查看更多情报信息。

Other References for CVE-2026-61820 (2)

Same Patch Batch · pgpartman · 2026-09-18 · 7 CVEs total

CVE-2026-61781 9.9 CRITICAL pg_partman has privilege escalation through SQL injection in create_partition_time()
CVE-2026-61817 8.5 HIGH pg_partman privilege escalation via SQL injection in several functions via time decoder
CVE-2026-61818 8.5 HIGH pg_partman SQL injection in undo partition time encoder
CVE-2026-61819 8.5 HIGH pg_partman privilege escalation via SQL injection in when using pg_jobmon and encountering
CVE-2026-61821 8.5 HIGH pg_partman authorization bypass to move child tables between schemas during retention
CVE-2026-61822 6.5 MEDIUM pg_partman disable maintenance for all partition sets

IV. Related Vulnerabilities

V. Comments for CVE-2026-61820

No comments yet


Leave a comment