| From: | Pigsty via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org> |
|---|---|
| To: | PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org> |
| Subject: | PIG v1.0 Released with PGEXT.CLOUD : 444 PG extensions on 14 Linux |
| Date: | 2026-01-30 07:37:14 |
| Message-ID: | 176975863408.803.14668419087576857831@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce |
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/)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrei Krylosov via PostgreSQL Announce | 2026-02-02 07:30:02 | pg-status: microservice for checking the status of PostgreSQL hosts |
| Previous Message | pgDay Paris via PostgreSQL Announce | 2026-01-26 16:49:56 | pgDay Paris 2026 - Schedule is posted! |