PIG CLI

— Postgres Install Genius, the missing extension package manager for PostgreSQL ecosystem

Introduction
Why we need a package manager
 Get Started
Tutorial and examples
 Installation
Install in different ways

Quick Start

Install pig with a single command

curl -fsSL https://repo.pigsty.io/pig | bash     # via Cloudflare
curl -fsSL https://repo.pigsty.cc/pig | bash     # via China Mirror

Then it’s ready to use, assume you want to install the pg_duckdb extension:

$ pig repo set                  # overwrite Linux, Pigsty + PGDG repo in one-pass!
$ pig install pg18              # install PostgreSQL 18 kernel package from official PGDG repo
$ pig install pg_duckdb -v 18   # install pg_duckdb extension for PG 18 from pigsty repo
$ pig install -y postgis timescaledb  # install some extension for active postgres installation
$ pig install -y vector         # use both pkg and ext name to install extensions

CLI Usage

Check sub-commands documentation with pig help <command>

pig repo
Manage software repositories
 pig ext
Manage postgres extensions
 pig build
Build extension from source
 pig sty
Manage pigsty installation
pig pg
Manage local PostgreSQL
 pig pt
Manage Patroni HA cluster
 pig pb
Manage pgBackRest backup
 pig pitr
Orchestrated PITR recovery

About

The pig CLI is developed by Vonng, and open-sourced under the Apache License 2.0.

You can also check the pigsty project, which makes it even smoother to deliver all these extensions in an IaC way:

PGEXT
This Website and Extension Catalog
 PIG
The PostgreSQL Package Manager
 PIGSTY
The Battery-Included PostgreSQL Distribution
Last updated on