Skip to content

POSTGRESQL + EXTENSIONS → RPM / DEB

PostgreSQL package manager

Install PostgreSQL and extensions. Manage everyday database operations. PIG configures repositories, finds the matching package names, and installs them through apt or dnf.

PostgreSQL 14–18 · EL / Debian / Ubuntu

Download Get started
PIG package delivery flow PIG resolves packages from Pigsty, 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 pgsql · infra · extra PG PGDG postgresql.org OS OS Base EPEL · Debian · Ubuntu $ PIG ONE STATIC BINARY repo · ext · install catalog · packages · build pg · pt · pb · pitr pig install postgis deliver PG PostgreSQL 14–18 · RPM / DEB EX Extensions Find · Install · Update catalog ≡ Package catalog OS · arch · PG major

COVERAGE

Find extensions for your PostgreSQL environment

603 Extensions indexed 5 PostgreSQL majors (14–18) 8 Linux releases 2 CPU architectures (x86_64 / ARM64)

PACKAGE MANAGEMENT

CatalogRepositoriesBuildInstall

Find packages for your operating system, CPU architecture, and PostgreSQL major version.

COMMAND SURFACE

Choose a command for your task

Use pig help to list commands and pig help <command> for detailed usage.

Command reference → Installation → Release notes →
POPULAR EXTENSIONS
postgisvectortimescaledbcituspg_duckdbpg_searchdocumentdbpg_cronpostgisvectortimescaledbcituspg_duckdbpg_searchdocumentdbpg_cron
pg_partmanpgauditpg_repackpgroutingplv8pg_graphqlpgmqvchordpg_partmanpgauditpg_repackpgroutingplv8pg_graphqlpgmqvchord
Browse the extension catalog →

WHY IT EXISTS

Install packages by extension name

Package names differ across systems. PIG selects the name for your host and PostgreSQL version.

ONE EXTENSION

Different systems, different package names

  • pgvector on EL: pgvector_18
  • On Debian / Ubuntu: postgresql-18-pgvector
  • The package name also depends on the PostgreSQL major version

ONE INSTALL COMMAND

pig install vector -v 18

  • PIG detects the operating system and CPU architecture
  • It selects the package for your PostgreSQL version
  • It uses apt or dnf to resolve dependencies and install

You can also use the Pigsty repositories with apt or dnf directly. PostgreSQL runs without a PIG service.

SCRIPTS AND AGENTS

Inspect commands and read structured results

Use JSON help to inspect arguments, output support, and confirmation requirements. Recovery workflows also provide plans that scripts and agents can inspect before execution.

ANCS pig -o json --helpList subcommands, options, required users, and confirmations pig context -o jsonCollect host, PostgreSQL, Patroni, backup, and extension status -o json | yamlRead JSON or YAML results from commands that support them --plan · --yesInspect the recovery plan, then confirm execution

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 run apt install pig or dnf install pig. On Linux or macOS, you can also install the binary from a release archive.

rpmdebtarballmacOS
See the download matrix
Start with the tutorial Read the source on GitHub