The PostgreSQL extension package manager `pig` v1.0 is now generally available alongside [PGEXT.CLOUD](https://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](https://pgext.cloud/list/).
## 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](https://pgext.cloud/os/) 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](https://pgext.cloud/pig/) - **Expanded PostgreSQL 18 coverage**, including support for [Apache AGE](https://pgext.cloud/e/age/), [Citus](https://pgext.cloud/e/citus/), [ParadeDB pg_search](https://pgext.cloud/e/pg_search/), and [DocumentDB](https://pgext.cloud/e/documentdb/). - **Newly added extensions**: [pg_clickhouse](https://pgext.cloud/e/pg_clickhouse/), [pg_textsearch](https://pgext.cloud/e/pg_textsearch/), [pg_ttl_index](https://pgext.cloud/e/pg_ttl_index/), [etcd_fdw](https://pgext.cloud/e/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](https://pgext.cloud/repo/gpg/). - **DIY RPM/DEB Builds**: Extensions can be rebuilt via [`pig build`](https://pgext.cloud/pig/cmd/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](https://github.com/pgsty/pig) | [Website](https://pgext.cloud) | [Documentation](https://pgext.cloud/pig/)
