pig v0.3 released: Build 400+ extensions with the extension wizard!

From: Pigsty via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: pig v0.3 released: Build 400+ extensions with the extension wizard!
Date: 2025-03-07 19:48:56
Message-ID: 174137693665.680.10371655755029760412@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

[pig](https://pigsty.io/ext/pig) is a Go-based package manager built to tame Postgres and its extension ecosystem of [400+](https://pigsty.io/ext/list) extensions in one fell swoop. it piggyback your system’s native package manager (APT, YUM, DNF) and follow official
PGDG packaging conventions to ensure a glitch-free fit and out-of-box experience.

With the latest [v0.3](https://github.com/pgsty/pig/releases/tag/v0.3.0) release, pig is now capable of [building](https://pigsty.io/ext/pig/build) extensions, The new `pig build` subcommand streamlines building over 400 PG extensions with just a few commands. What once required custom scripts for automation is now fully integrated, allowing quick setups for building extensions like toolchain, rust & pgrx. Even if your Linux distro isn't officially supported in the Pigsty Repo, you can still easily build RPM/DEB packages for yourselves.

## Resource

- [GitHub Repo](https://github.com/pgsty/pig)
- [Extension Repo](https://pigsty.io/ext/list)
- [PIG v0.3 ReleaseNote](https://github.com/pgsty/pig/releases/tag/v0.3.0)
- [Blog: The Ideal Way to deliver PG Extensions](https://medium.com/@fengruohang/the-idea-way-to-deliver-postgresql-extensions-35646464bb71)

## Get Started

```bash
curl -fsSL https://repo.pigsty.io/pig | bash
pig repo add all -u # add all repos and update cache
pig ext install pg17 # install native PGDG PostgreSQL 17 kernels
pig ext install documentdb # install the documentdb extension (for current pg17)
```

To build extensions:

```bash
curl https://repo.pigsty.cc/pig | bash # Install pig
pig build repo # Add upstream repositories
pig build tool # Install build tools
pig build rust # Configure Rust/PGRX toolchain (optional)
pig build spec # Download build specifications
pig build proxy # Configure proxy
pig build get citus # Download source tarball (take citus for example)
pig build ext citus # Build the extension from source (citus example)
```

Browse pgsql-announce by date

  From Date Subject
Next Message UCLL via PostgreSQL Announce 2025-03-07 19:49:21 PGConf.BE : Call for speakers and Registrations open
Previous Message Slonik Events Canada via PostgreSQL Announce 2025-03-06 01:45:36 PGConf.dev 2025 Schedule Announced!