Extension Repo

When deploying PostgreSQL with Pigsty, repo configure is handled automatically. You don’t need to manage repositories manually.

However, if you want to use the Pigsty extension repository independently (e.g., to install 400+ additional extensions for existing PostgreSQL deployments), this section will guide you through the process.

The PostgreSQL Global Development Group (PGDG) maintains the official YUM/APT repo for PostgreSQL. Pigsty provides a complementary repository (similar to EPEL for RHEL) that offers additional RPM/DEB packages for PostgreSQL extensions and ecosystem tools, maintaining full compatibility with PGDG’s build specifications.

The Pigsty extension repository supports both x86_64 and aarch64 architectures, organized into two sub-repositories:

• pigsty-infra: Contains OS-version-independent infrastructure components (e.g., the Go-based vip-manager that works across different OS major version)
• pigsty-pgsql: Provides OS-version-specific PostgreSQL extensions, supporting EL 8/9, Debian 12, and Ubuntu 22.04/24.04 - totaling 10 major version-architecture combinations.

For supported operating systems, we provide the pig CLI tool for repository and extension management. It handles:

• Repository Management
• Extension Management

You can also use it as a common YUM / APT repo that follow the traditional way