pkg.soopen package index

brew / rank 4227

Install pg_partman with Homebrew, apt, dnf

Partition management extension for PostgreSQL. Version 5.5.0 via Homebrew; verified 2026-09-15. Also installable with debian: sudo apt install postgresql-17-partman.

Install commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install pg_partman

local Homebrew formula metadata

Linux

Debian aptverified · 92%
sudo apt install postgresql-17-partman

Debian stable package indexes · postgresql-17-partman · source: deb.debian.org

Fedora dnfverified · 92%
sudo dnf install pg_partman

Fedora Rawhide package metadata · pg_partman · source: dl.fedoraproject.org

Ubuntu aptverified · 92%
sudo apt install postgresql-16-partman

Ubuntu 24.04 LTS package indexes · postgresql-16-partman · source: archive.ubuntu.com

overview

Package summary

Partition management extension for PostgreSQL

Commands and aliases

  • check_unique_constraint.py
  • dump_partition.py
  • vacuum_maintenance.py

history

Project history and usage

pg_partman is a PostgreSQL extension that creates and maintains time- or number-based partition sets, including future partition creation, retention, migration, and background maintenance.

Project history

pg_partman began as a PostgreSQL extension for managing time- and number-based partition sets, including the trigger-based techniques required by older PostgreSQL releases. As PostgreSQL's declarative partitioning matured, pg_partman added support for the core implementation and migration tooling.

The 5.x series completed a major architectural transition: version 5.0.1 dropped trigger-based partitioning, required PostgreSQL 14 or newer, and standardized on built-in declarative partitioning. Later 5.x releases expanded supported partitioning forms and maintenance capabilities.

Adoption history

pg_partman is distributed not only from source but through community-maintained PostgreSQL operating-system packages. Its usefulness grew as PostgreSQL installations needed repeatable automation for creating future partitions, applying retention, and maintaining large time-series or sequence-based tables.

How it is used

Administrators create the extension in a chosen database schema, register existing declaratively partitioned parent tables, and configure policies in pg_partman's database configuration tables. Maintenance can be invoked by a scheduler or automated with the bundled background worker; retention, premaking, migration, and monitoring features support production partition lifecycles.

Why package nerds care

The extension packages a substantial amount of PostgreSQL partitioning operational knowledge into database objects and an optional background worker. Package maintainers must track both PostgreSQL-version compatibility and major pg_partman migrations, particularly the transition away from trigger-based partitioning.

Timeline

  • Pre-5.0: pg_partman supported older trigger-based partitioning alongside PostgreSQL declarative partitioning.
  • 2023: The 4.7 series added compatibility with PostgreSQL 16.
  • 2024: Version 5.0.1 removed trigger-based partitioning and required PostgreSQL 14 or newer.
  • 2025: The 5.x documentation described list partitioning and experimental numeric partitioning support.

Related projects

  • PostgreSQL
  • pg_jobmon
  • pgTAP

security posture

Risk level: blue

broad file, network, media, or database tool signal.

Risk classifier

blue risk · medium confidence · tool

Why

  • broad file, network, media, or database tool signal

Signals

  • text:sql

Install behavior

  • No Homebrew post-install hook is recorded in formula metadata.
  • Homebrew bottle metadata is available for 6 platform targets.
  • Build metadata lists 2 build dependencies.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

executables

Installed executables

CommandKindExposureNote
check_unique_constraint.pycliglobal executable
dump_partition.pycliglobal executable
vacuum_maintenance.pycliglobal executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-09-19
manager version5.5.0
manager updated2026-09-15
local dataok
upstreamcurrent
latest detectedv5.5.0

https://github.com/pgpartman/pg_partman

  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:pg_partman
Version5.5.0
Package managerHomebrew
Package manager pagehttps://formulae.brew.sh/formula/pg_partman
Homepagehttps://github.com/pgpartman/pg_partman
Repositoryhttps://github.com/pgpartman/pg_partman
LicensePostgreSQL
Source archivehttps://github.com/pgpartman/pg_partman/archive/refs/tags/v5.5.0.tar.gz
Last updated2026-09-15T01:40:46Z
Pulseupdated
Build dependenciespostgresql@17, postgresql@18
Bottleavailable (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-installnot defined
Servicenone declared

registry facts

Source database details

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namepg_partman
Version Scheme0
Revision0
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedno
Disabledno
Keg Onlyno
URL Keys
  • stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

Debian apt95%

postgresql-17-partman 5.2.4-1

PostgreSQL Partition Manager

https://github.com/pgpartman/pg_partman

sudo apt install postgresql-17-partman
  • Section: database
  • Architecture: amd64
  • Source Package: pg-partman
  • 5 dependencies
  • normalized package name match
  • Matched by: Pg Partman
Debian stable package indexes · deb.debian.org · Debian stable package indexes: postgresql-17-partman from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz
Ubuntu apt95%

postgresql-16-partman 5.0.1-1

PostgreSQL Partition Manager

https://github.com/pgpartman/pg_partman

sudo apt install postgresql-16-partman
  • Section: universe/database
  • Architecture: amd64
  • Source Package: pg-partman
  • 5 dependencies
  • normalized package name match
  • Matched by: Pg Partman
Ubuntu 24.04 LTS package indexes · archive.ubuntu.com · Ubuntu 24.04 LTS package indexes: postgresql-16-partman from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz
dnf95%

pg_partman 5.4.3-3.fc45

PostgresSQL Partition Manager

https://github.com/pgpartman/pg_partman

sudo dnf install pg_partman
  • License: PostgreSQL
  • Category: Unspecified
  • Architecture: x86_64
  • Source Package: postgresql18-pg_partman
  • 4 dependencies
  • 4 provides
  • normalized package name match
  • Matched by: Pg Partman
Fedora Rawhide package metadata · dl.fedoraproject.org · Fedora Rawhide package metadata: pg_partman from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/652278618dec9c023176a80c435a32a2c8154869fb0eb662c267a54df28d77d9-primary.xml.zst

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

Same workflow

  • pgbouncerShares pkgdb curated category or tags: cli, database, database-admin, developer-tools, postgresql.
  • pgcliShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pgbadgerShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pg-schema-diffShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pgbackrestShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.
  • pgcopydbShares pkgdb curated category or tags: cli, database, developer-tools, postgresql.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

  • Geiger risk classifier
  • cross-ecosystem install command graph
  • curated package history
  • external package-manager database matches
  • package relationship graph
  • package version freshness
  • package-page enrichment
  • pkg.so package database
  • pkgdb category and tag curation