PIG

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 …

Use pig pitr to restore a local PostgreSQL instance from pgBackRest backups. For a managed restore, PIG stops services as needed and restores the data. By default, it then starts PostgreSQL and leaves Patroni stopped for you to verify the recovered …

pig pgbackrest (alias pig pb) creates backups, restores data, and manages pgBackRest stanzas. It runs pgBackRest as the PostgreSQL operating-system user, selected by --dbsu or $PIG_DBSU (default postgres). Before the first backup, install pgBackRest …

Use pig pe to read metrics from a running pg_exporter and reload its configuration. The full command name is pig pg_exporter. Aliases are pe, pgexp, and pgexporter. pig pe get # Show PostgreSQL metrics pig pe list # List PostgreSQL metric families …

pig patroni (alias pig pt) runs the installed patronictl command. Use it to inspect cluster members, change cluster configuration, and switch the primary. PIG selects the configuration file and provides local service, status, and log commands. Other …

pig postgres (alias pig pg) manages local PostgreSQL instances and databases. Use it to initialize or control an instance, run SQL, maintain tables, and create database copies. Use pig pt for Patroni cluster operations and pig pitr for recovery with …

pig do runs administration playbooks from the selected Pigsty directory. It uses the inventory to add clusters, create databases and users, install packages, or remove services. Define the target configuration in the inventory first, then run the …

pig inventory (alias pig inv) inspects, edits, and validates the Pigsty inventory, pigsty.yml. It also checks deployment prerequisites and exchanges configuration with PostgreSQL through the experimental cmdb commands. When you edit a fragment, PIG …

pig sty installs Pigsty, prepares the controller, generates configuration, and runs deployment playbooks. It also manages dashboards through the Grafana HTTP API. Command Purpose sty init Download and extract Pigsty into an installation directory sty …

pig build downloads sources, installs dependencies, and produces RPM/DEB packages using Pigsty build recipes. Use it on an EL, Debian, or Ubuntu build host. Rust, pgrx, and the Xray client also support their respective macOS workflows. Command …

pig ext searches the extension catalog and installs, updates, or removes PostgreSQL extension packages on the host. It also supports PostgreSQL server packages. After installing a package, apply the SQL and configuration required by the extension. …

pig repo manages Linux package repositories. Use it to add or remove APT/YUM/DNF sources, refresh indexes, and create or extract offline bundles. repo create also supports macOS through SOW. Command Description Notes repo list Print available …

pig manages PostgreSQL packages, local database services, and Pigsty deployments. Choose a command below for your task. Use pig COMMAND --help to see the options supported by your installed program. pig repo: manage software repositories pig ext: …

The latest stable version is v1.10.0. Version Date Summary GitHub v1.10.0 2026-10-17 603 catalog entries, PostgreSQL target and recovery safety, faithful Inventory, automation fixes v1.10.0 v1.9.0 2026-10-06 600 catalog entries, Xray roles, …

Install PIG with the Linux installer, a system package, or a release archive. The current version is v1.10.0. The download page lists all release files. Script installation On Linux, run: curl -fsSL https://repo.pigsty.io/pig | bash In mainland …

PIG is a command-line tool for installing and managing PostgreSQL and its extensions. It maps extension names to RPM or DEB packages and uses apt, dnf, or yum to install them. The catalog contains 603 extension entries. PIG selects package names for …

This tutorial installs PostgreSQL 18 and pgvector, starts a local test instance, and enables the extension in a database. Use a supported Linux test host with internet access and curl installed. You need root or sudo access. Run the commands in …