PIG v1.0 Released with PGEXT.CLOUD : 444 PG extensions on 14 Linux

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/)

Browse pgsql-announce by date

  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!