Docs Blog Download & Install 简体中文 GitHub

THE POSTGRESQL EXTENSION PACKAGE MANAGER

Packager Index Gateway

One gateway to PostgreSQL extension packages. 575 catalog entries · PostgreSQL 14-18 · EL / Debian / Ubuntu

One CLI to search the catalog, configure repositories, and install native RPM / DEB. Availability is target-specific.

Get Started Documentation
$ curl -fsSL https://repo.pigsty.io/pig | bash

COVERAGE

575 Extension Entries, Indexed by Target

575 Cataloged Extensions 5 PostgreSQL Majors (14-18) 8 Linux Distro Majors × 2 Arches 0 Database Runtime Dependencies

VALUE PROPOSITION

CatalogRepositoriesBuildInstall

From catalog lookup and repository setup to on-demand builds and native installation—every step is target-aware.

COMMAND SURFACE

One CLI Across the Lifecycle

Every command is discoverable through pig help; machine consumers use structured output where supported.

Command Reference → Installation → Release Notes →
ONE COMMAND AWAY
postgisvectortimescaledbcituspg_duckdbpg_searchdocumentdbpg_cronpostgisvectortimescaledbcituspg_duckdbpg_searchdocumentdbpg_cron
pg_partmanpgauditpg_repackpgroutingplv8pg_graphqlpgmqvchordpg_partmanpgauditpg_repackpgroutingplv8pg_graphqlpgmqvchord
Browse all 575 extensions →

WHY IT EXISTS

Installing an Extension Shouldn't Be a Project

The hard part is not the extension—it is reliable delivery across versions, systems, and architectures.

WITHOUT PIG

Manual at Every Layer

  • Find the right repository, package, or source
  • Match the PG major, OS release, and architecture
  • Own the toolchain and build when no binary exists
  • Repeat the process for every host and major upgrade

WITH PIG

One Consistent Workflow

  • repo set writes region-aware apt / dnf configuration
  • install resolves names, PG majors, systems, and architectures
  • build provides a spec-driven path when no package exists
  • The result stays native RPM / DEB, with no database runtime dependency

PIG remains optional: the Pigsty repositories work with plain apt and dnf, and PIG never becomes a database runtime dependency.

AGENT-NATIVE CLI

Understand First. Orchestrate Safely.

PIG is more than scriptable: ANCS exposes capabilities, risk, and confirmation requirements as machine-readable schema. Unified results, context snapshots, and reviewable plans let agents understand before they act.

ANCS pig -o json --helpCapability tree with risk, confirm, os_user, and other execution boundaries pig context -o jsonOne snapshot of host, PostgreSQL, Patroni, backup, and extension context -o json | yamlUnified Result envelopes, stable status codes, and machine-readable output --plan · --yesRisk-sensitive actions expose plans and require explicit confirmation

DOWNLOAD

Get PIG

Use the one-line installer, your system package manager, or the release binary.

INSTALL SCRIPT

One Line

curl -fsSL https://repo.pigsty.io/pig | bash

The script detects your OS and architecture, fetches the matching RPM / DEB, and hands it to rpm or dpkg.

EL 8/9/10Debian 12/13Ubuntu 22/24/26amd64 · arm64
Read the install guide

PACKAGE OR BINARY

apt / dnf

Add the Pigsty Infra repository, then apt install pig or dnf install pig. Or just take the binary out of the release tarball and drop it on your PATH.

rpmdebtarballmacOS
See the release artifacts
Start with the tutorial Read the source on GitHub