PIG 1.10.0 Documentation

Install, manage, and build PostgreSQL and its extensions with the pig CLI.

Current stable version: v1.10.0. Read the release notes.

PIG provides commands to find, install, and build PostgreSQL extension packages. It also manages PostgreSQL, Patroni, pgBackRest, and Pigsty workflows. Package installation uses the system’s apt, dnf, or yum.

Start here

Your task	Page
Install PostgreSQL and enable your first extension	Getting started
Learn what PIG does and which platforms it supports	Introduction
Download, install, update, or remove PIG	Installation
Look up commands, options, and automation features	Command reference

Install PostgreSQL and extensions

On a Linux host with root or sudo access, run:

curl -fsSL https://repo.pigsty.io/pig | bash
sudo pig repo add pgsql --update
sudo pig install -v 18 pg18 vector

In mainland China, use https://repo.pigsty.cc/pig for the installer. These commands install PostgreSQL 18 and pgvector packages. Continue with Getting started to start a test instance and enable the extension with CREATE EXTENSION vector.

Command reference

Task	Command
Configure APT/DNF repositories	`pig repo`
Query the catalog, install, or update extension packages	`pig ext`, `pig install`
Build extension packages from source	`pig build`
Manage local PostgreSQL instances and databases	`pig pg`
Manage Patroni clusters through patronictl	`pig pt`
Inspect or reload pg_exporter	`pig pe`
Back up and restore with pgBackRest	`pig pb`
Run point-in-time recovery	`pig pitr`
Install and configure Pigsty, manage Grafana	`pig sty`
Read, edit, and validate Pigsty inventory	`pig inventory`
Run Pigsty administration playbooks	`pig do`
Collect host, database, and backup status	`pig context`

Run pig help <command> for command help. For automation, use pig -o json --help to inspect command capabilities, then select the relevant output and plan options.

Find more information

Press Ctrl with K (⌘ with K on macOS) to search the site. Press / for page actions. An AI assistant action sends the public page URL and a reading prompt to the selected service.

Design Records: implementation decisions, trade-offs, and proposals.
Release notes: changes and download files for each version.
Extension catalog: extension descriptions and package information.
GitHub Issues: report a problem or request a feature.

PIG is developed by Vonng and released under Apache 2.0. Pigsty provides PostgreSQL deployment, monitoring, backups, and high availability.

Getting Started

Install PostgreSQL and pgvector, start an instance, and enable the extension

Introduction

What PIG does, how package installation works, and which platforms it supports

Installation

How to download and install the pig package manager

Release

pig — PostgreSQL Package Manager Release Notes

pig

pig CLI command reference overview

pig repo