Usage
How to install PostgreSQL extensions using the Pigsty extension repository
Pigsty provides three pieces of infrastructure to help users harness the collaborative superpowers of the PostgreSQL extension ecosystem:
- Extension Catalog: Browse detailed information, usage, metadata, download links and docs for 464 extensions
- Extension Repository: Get pre-built RPM/DEB binary packages, available on 14 Linux systems
- Package Manager: Use the
pigCLI tool to abstract away OS and architecture differences for one-click extension installation
Quick Start
curl -fsSL https://repo.pigsty.cc/pig | bash # Install the pig CLI tool
pig repo add pigsty pgdg -u # Configure the Pigsty & PGDG software repos
pig install pg18 # Install PostgreSQL 18 kernel from the PGDG official repo
pig install pg_duckdb -v 18 # e.g., install pg_duckdb for PG 18 (version flag can be omitted if PG18 is in PATH)
Extension Repository
The Pigsty extension repository contains RPM/DEB packages from the following three sources:
| Repository | Description |
|---|---|
| PGDG | PostgreSQL Global Development Group official repo, providing the PG kernel and core extensions |
| PIGSTY | Pigsty-maintained supplementary repo, providing additional extensions not in PGDG |
| CONTRIB | PostgreSQL built-in contrib extension modules, installed alongside the kernel |
The repository is globally distributed via Cloudflare CDN, with an accelerated mirror for mainland China.
To install extensions, you need to add both repositories (PGDG and PIGSTY) for the kernel and extensions, as well as your operating system’s default software repository for required dependencies.
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.