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

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

$ pig repo add pigsty pgdg -u  # add pgdg & pigsty repo, then update repo cache
$ pig ext install pg17         # install PostgreSQL 17 kernels with native PGDG packages
$ pig ext install pg_duckdb    # install the pg_duckdb extension (for current pg17)

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

Source

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:

Last updated on