PIGSTY

PIG CLI

The Missing Package Manager for PostgreSQL Extensions

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

Quick Start

Get started with PIG in seconds:

curl -fsSL https://repo.pigsty.io/pig | bash
curl -fsSL https://repo.pigsty.cc/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)

Get Started

Quick start for PIG CLI

Installation

Install PostgreSQL extensions

Why Use PIG?

Why we need a package manager for postgres?

Release Note

Release notes for PIG CLI

Commands

Check sub-commands documentation with pig help <command>:

pig

Main CLI interface for the command line tool

pig repo

Manage repositories for your linux distribution

pig ext

Install, remove, search, scan postgres extensions

pig build

Setup building env for extensions and build them

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.