The PostgreSQL extension package manager pig v1.0 is now generally available alongside PGEXT.CLOUD, an open infrastructure for extension discovery and binary delivery. The catalog lists 444 extensions with an availability matrix for PostgreSQL 13–18. See the Extension Catalog.

Background

The PostgreSQL extension ecosystem is large (1,000+), while the official PGDG repositories package approximately 150. PGEXT.CLOUD aims to narrow the installability gap by shipping Linux-native RPM/DEB packages across 14 mainstream Linux distributions and multiple PostgreSQL major versions.

What's New in This Release

• PIG v1.0 GA: A CLI tool for installing PostgreSQL extensions via native package managers. Documentation
• Expanded PostgreSQL 18 coverage, including support for Apache AGE, Citus, ParadeDB pg_search, and DocumentDB.
• Newly added extensions: pg_clickhouse, pg_textsearch, pg_ttl_index, etcd_fdw.

Key Properties

• Linux-native packages: RPM/DEB packages designed to integrate cleanly with distribution package managers.
• PGDG-compatible: Designed to work alongside official PostgreSQL packages and repositories.
• GPG-signed: All repository packages are signed. Details and fingerprints: GPG Key.
• DIY RPM/DEB Builds: Extensions can be rebuilt via pig build.

Getting Started

bash curl -fsSL https://repo.pigsty.io/pig | bash pig repo set pig install pg18 pig install pg_duckdb -v 18

Links: GitHub | Website | Documentation