PostgreSQL Extension Repo

The supplementary APT and YUM repo for PostgreSQL extensions, maintained and used by Pigsty

Provide 351 available Extensions as RPM / DEB for PostgreSQL 13 - 17 in addition to the official PGDG repo.

Available on Linux: Debian 12 / Ubuntu 24.04 / 22.04 / EL8 / EL9 compatible OS distros, and x86_64 & ARM64 architectures.

Entry / Filter	All	PGDG	PIGSTY	CONTRIB	MISC	MISS	PG17	PG16	PG15	PG14	PG13
RPM Extension	345	116	156	69	4	6	321	340	343	331	313
DEB Extension	338	103	162	69	4	13	319	333	336	329	310

Why extension matters to PostgreSQL? check the post: "PostgreSQL is eating the database world!"

Why using this repo? check the post: The idea way to deliver PostgreSQL extensions

The idea way to deliver PostgreSQL extensions

---

Get Started

Pig CLI

You can use the pig cli tool (pg package manager) or just use the traditional way. It's up to you.

curl -fsSL https://repo.pigsty.io/pig | bash  # install pig rpm/deb package
$ pig repo add pigsty pgdg -u                 # add pgdg & pigsty repo, update cache      
$ pig ext install pg17                        # install PostgreSQL 17 kernels with PGDG native packages
$ pig ext install pg_duckdb                   # install the pg_duckdb extension (for current pg17)

APT Repo

All rpm/deb packages are signed with GPG key B9BD8B20 (9592A7BC7A682E7333376E09E7935D8DB9BD8B20 ).

For Ubuntu 22.04 / 24.04 & Debian 12 or any compatible platforms, use the following commands:

curl -fsSL https://repo.pigsty.io/key | sudo gpg --dearmor -o /etc/apt/keyrings/pigsty.gpg  # add gpg key
sudo tee /etc/apt/sources.list.d/pigsty-io.list > /dev/null <<EOF
deb [signed-by=/etc/apt/keyrings/pigsty.gpg] https://repo.pigsty.io/apt/infra generic main 
deb [signed-by=/etc/apt/keyrings/pigsty.gpg] https://repo.pigsty.io/apt/pgsql/$(lsb_release -cs) $(lsb_release -cs) main
EOF
sudo apt update;  # sudo apt install pig

YUM Repo

For EL 8/9 and compatible platforms, use the following commands to add the YUM repo:

curl -fsSL https://repo.pigsty.io/key      | sudo tee /etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty >/dev/null  # add gpg key
curl -fsSL https://repo.pigsty.io/yum/repo | sudo tee /etc/yum.repos.d/pigsty.repo        >/dev/null  # add repo file
sudo yum makecache; # sudo yum install pig 

---

What's Inside

Linux x86_64/amd64 Extension packages for PostgreSQL 12 - 17, on El8, EL9, Ubuntu 22.04 and Debian 12.

Check the extension list for details.

---

Contrib

If you have any suggestions on including new extensions or bumping to new versions, or find any mistake about metadata, PR or Issue are welcome!

You can edit the pigsty.csv raw data and create a pull request to update the metadata.

---

Compatibility

pig runs on: RHEL 8/9, Ubuntu 22.04/24.04, and Debian 12, on both amd64/arm64 arch

Code	Distribution	x86_64	aarch64
el9	RHEL 9 / Rocky9 / Alma9 / ...	PG 17 - 13	PG 17 - 13
el8	RHEL 8 / Rocky8 / Alma8 / ...	PG 17 - 13	PG 17 - 13
u24	Ubuntu 24.04 (noble)	PG 17 - 13	PG 17 - 13
u22	Ubuntu 22.04 (jammy)	PG 17 - 13	PG 17 - 13
d12	Debian 12 (bookworm)	PG 17 - 13	PG 17 - 13

Here are some bad cases and limitation for above distros:

• pg_duckdb el8:*:*
• pljava: el8:*:*
• pllua: el8:arm:13,14,15
• h3: el8.amd.pg17
• jdbc_fdw: el:arm:*
• pg_partman and timeseries: u24:*:13
• wiltondb: d12:*:*

---

About