Pgpartman pg_partman
pg_partman authorization bypass to move child tables between schemas during retention
pg_partman is a PostgreSQL extension that manages partitioned tables by time or ID. Prior to 5.5.0, drop_partition_id() and drop_partition_time() use part_config.retention_schema as the target for ALTER TABLE SET SCHEMA and accept any nonempty schema name. A role with partman_user access can select a target schema where the role lacks the normal CREATE privilege, and the background worker performs the relocation with pg_partman_bgw.role privileges, which default to PostgreSQL superuser, bypassing the authorization check that a normal ALTER TABLE SET SCHEMA operation would enforce. This permits unauthorized relocation of retained child tables between schemas. This issue is fixed in version 5.5.0.
Affected versions and mitigation
From the CVE record and the vendor's references.Affected
- < 5.5.0
Fixed in 5.5.0
Mitigation
Upgrade pg_partman to 5.5.0 or later.
References
- Vendor advisory github.com/pgpartman/pg_partman/security/advis…
- Patch github.com/pgpartman/pg_partman/commit/ba94055…
- Release notes github.com/pgpartman/pg_partman/releases/tag/v…
Timeline
Days relative to CVE publicationNo public PoC found yet; not in CISA KEV.
PoC repositories
Found on GitHub.No PoC repositories found yet.