# PIG: Packager Index Gateway

> PIG is a PostgreSQL extension package manager: resolve and install PostgreSQL 14-18 and cataloged extension packages on EL, Debian, and Ubuntu with one self-contained CLI.


LLMS index: [llms.txt](/llms.txt)

PIG is a command-line package manager for PostgreSQL and its extensions. It piggybacks on the
native `apt` and `dnf` package managers, hiding the differences between distributions, CPU
architectures, and PostgreSQL major versions behind a handful of commands.

Start with the [Getting Started](/start/) tutorial, read [why pig exists](/intro/), or jump
straight to [installation](/install/).


## Documentation index

- [Getting Started](https://pig.pgsty.com/start/index.md): Quick start with pig, the PostgreSQL package manager
- [Introduction](https://pig.pgsty.com/intro/index.md): What PIG manages, where it helps, and where its package-management boundary ends
- [Installation](https://pig.pgsty.com/install/index.md): How to download and install the pig package manager
- [pig](https://pig.pgsty.com/cmd/index.md): pig CLI command reference overview
- [pig repo](https://pig.pgsty.com/repo/index.md): Manage software repositories with pig repo
- [pig ext](https://pig.pgsty.com/ext/index.md): Search the extension catalog and manage PostgreSQL extension packages with pig ext
- [pig build](https://pig.pgsty.com/build/index.md): Build PostgreSQL extensions from source with pig build
- [pig sty](https://pig.pgsty.com/sty/index.md): Manage Pigsty installation with pig sty
- [pig do](https://pig.pgsty.com/do/index.md): Run bounded Pigsty administrative playbook tasks with pig do
- [pig inventory](https://pig.pgsty.com/inventory/index.md): Inspect, edit, validate, check, and exchange the Pigsty Inventory
- [pig postgres](https://pig.pgsty.com/pg/index.md): Manage local PostgreSQL server with pig postgres subcommand
- [pig patroni](https://pig.pgsty.com/pt/index.md): Run patronictl transparently, with Pigsty service, config, and log helpers
- [pig pe](https://pig.pgsty.com/pe/index.md): Use the legacy pig pe shortcuts for a default pg_exporter HTTP endpoint
- [pig pgbackrest](https://pig.pgsty.com/pb/index.md): Manage pgBackRest backup and restore primitives with pig pgbackrest
- [pig pitr](https://pig.pgsty.com/pitr/index.md): Perform orchestrated point-in-time recovery (PITR) with pig pitr


- [Design Notes](https://pig.pgsty.com/design/index.md): Design notes on the decisions, trade-offs, and implementation boundaries behind PIG.

- [Release Notes](https://pig.pgsty.com/release/index.md): Release notes for every pig version