PostgreSQL Extension Catalog

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

Provide 423 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 distros, and x86_64 & ARM64 arch.

Entry	All	PGDG	PIGSTY	CONTRIB	MISC	MISS	PG17	PG16	PG15	PG14	PG13
RPM	417	119	227	71	0	6	399	407	410	394	368
DEB	410	103	236	71	0	13	397	400	403	391	363

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.

You can also suggest new extensions here

---

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 limitations for the above distros:

• pg_duckdb el8:*:*
• pljava: el8:*:*
• pllua: el8:arm:13,14,15
• h3: el8.amd.pg17
• jdbc_fdw: el:arm:*
• pg_partman: u24:*:13
• wiltondb: d12:*:*
• citus and hydra are mutually exclusive
• pg_duckdb and pg_mooncake are mutually exclusive
• pg_duckdb will invalidate duckdb_fdw
• documentdb_core is not available on arm arch
• vchord 0.2+ is not available on d12/u22 (0.1 available)

---

About