Skip to content

POSTGRESQL + EXTENSIONS → RPM / DEB

Postgres Install Guide

One command installs PostgreSQL and its extensions. Wire native repositories, resolve packages for the target system, and deliver RPM / DEB with one static binary.

575 extensions · PostgreSQL 14–18 · EL / Debian / Ubuntu

Download Read the docs
PIG package delivery flow PIG resolves packages from Pigsty Infra, PGDG, and operating-system repositories, then uses one static binary to configure repositories, install extensions, and deliver native RPM and DEB packages for PostgreSQL 14 through 18. UPSTREAM PIG DELIVERS PI Pigsty Infra pgsql · infra · extra PG PGDG postgresql.org OS OS Base EPEL · Debian · Ubuntu $ PIG ONE STATIC BINARY repo · resolve · verify ext · install · build pg · pt · pb · pitr pig install postgis deliver PG PostgreSQL 14–18 · RPM / DEB EX Extensions 575 packages catalog ≡ Package catalog OS · arch · PG major

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
Open the download page

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 download matrix
Start with the tutorial Read the source on GitHub