README.md

PostgreSQL Extension Repo

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

Contains 150+ PG extensions RPM / DEB for PostgreSQL 12 - 17 in addition to the official PGDG repo.

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

---

Get Started

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

APT Repo

For Ubuntu 22.04 & Debian 12 or any compatible platforms, use the following commands to add the APT repo:

curl -fsSL https://repo.pigsty.io/key | sudo gpg --dearmor -o /etc/apt/keyrings/pigsty.gpg
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

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

---

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.

---

About