Skip to content

PIG CLI

The Missing Package Manager for PostgreSQL Extensions

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

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 ext

Manage postgres extensions

pig sty

Manage pigsty installation

pig pg

Manage local PostgreSQL

pig pt

Run patronictl transparently

pig pb

Manage pgBackRest backup

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

Introduction

Why would we need yet another package manager? especially for Postgres extensions?

Get Started

Quick start guide for PIG, the PostgreSQL package manager

Installation

How to download and install the pig Package Manager

CMD Docs

Overview of the pig CLI command reference