Linux Repository
Pigsty has a repository that provides additional PostgreSQL extension packages on mainstream Linux Distros. It is designed to work together with the official PostgreSQL Global Development Group (PGDG) repo. Together, they can provide 576 packaged PostgreSQL extensions out-of-the-box.
| PGSQL Repo | Description | Link |
|---|---|---|
| PGSQL Repo | Pigsty Extension Repo, supplementary extension packages | pgsql.md |
| INFRA Repo | Pigsty Infrastructure Repo, monitoring/tools | infra.md |
| PGDG Repo | PGDG Official Repo Mirror, PG Kernel | pgdg.md |
| GPG Key | GPG Public Key, signature verification | gpg.md |
Compatibility Overview
| OS / Arch | OS | x86_64 | aarch64 |
|---|---|---|---|
| EL8 | el8 | 18, 17, 16, 15, 14 | 18, 17, 16, 15, 14 |
| EL9 | el9 | 18, 17, 16, 15, 14 | 18, 17, 16, 15, 14 |
| EL10 | el10 | 18, 17, 16, 15, 14 | 18, 17, 16, 15, 14 |
| Debian 12 | d12 | 18, 17, 16, 15, 14 | 18, 17, 16, 15, 14 |
| Debian 13 | d13 | 18, 17, 16, 15, 14 | 18, 17, 16, 15, 14 |
| Ubuntu 22.04 | u22 | 18, 17, 16, 15, 14 | 18, 17, 16, 15, 14 |
| Ubuntu 24.04 | u24 | 18, 17, 16, 15, 14 | 18, 17, 16, 15, 14 |
| Ubuntu 26.04 | u26 | 18, 17, 16, 15, 14 | 18, 17, 16, 15, 14 |
Get Started
You can enable the pigsty infra & pgsql repo with the pig CLI tool:
Manual Install
You can also add these repos to your system manually with the default apt, dnf, yum approach.
All the RPM / DEB packages are signed with GPG Key fingerprint (B9BD8B20) in Pigsty repository.
Repository Components
Pigsty has two major repos: INFRA and PGSQL,
providing DEB / RPM packages for x86_64 and aarch64 architecture.
The INFRA repo contains packages that are generic to any PostgreSQL version and Linux major version, including Prometheus & Grafana stack, admin tools for Postgres, and many utilities written in Go.
| Linux | Package | x86_64 | aarch64 |
|---|---|---|---|
| EL | rpm | ✓ | ✓ |
| Debian | deb | ✓ | ✓ |
The PGSQL repo contains packages that are ad hoc to specific PostgreSQL Major Versions (often ad hoc to a specific Linux distro major version, too). Including extensions and some kernel forks.
Compatibility Details
| OS Code | Vendor | Major | Minor | Fullname | PG Major Version | Comment |
|---|---|---|---|---|---|---|
el7.x86_64 | EL | 7 | 7.9 | CentOS 7 x86 | 15 14 13 | EOL |
el8.x86_64 | EL | 8 | 8.10 | RockyLinux 8 x86 | 18 17 16 15 14 | Near EOL |
el8.aarch64 | EL | 8 | 8.10 | RockyLinux 8 ARM | 18 17 16 15 14 | Near EOL |
el9.x86_64 | EL | 9 | 9.8 | RockyLinux 9 x86 | 18 17 16 15 14 | OK |
el9.aarch64 | EL | 9 | 9.8 | RockyLinux 9 ARM | 18 17 16 15 14 | OK |
el10.x86_64 | EL | 10 | 10.2 | RockyLinux 10 x86 | 18 17 16 15 14 | OK |
el10.aarch64 | EL | 10 | 10.2 | RockyLinux 10 ARM | 18 17 16 15 14 | OK |
d11.x86_64 | Debian | 11 | 11.11 | Debian 11 x86 | 17 16 15 14 13 | EOL |
d11.aarch64 | Debian | 11 | 11.11 | Debian 11 ARM | 17 16 15 14 13 | EOL |
d12.x86_64 | Debian | 12 | 12.15 | Debian 12 x86 | 18 17 16 15 14 | OK |
d12.aarch64 | Debian | 12 | 12.15 | Debian 12 ARM | 18 17 16 15 14 | OK |
d13.x86_64 | Debian | 13 | 13.6 | Debian 13 x86 | 18 17 16 15 14 | OK |
d13.aarch64 | Debian | 13 | 13.6 | Debian 13 ARM | 18 17 16 15 14 | OK |
u22.x86_64 | Ubuntu | 22 | 22.04.5 | Ubuntu 22.04 x86 | 18 17 16 15 14 | OK |
u22.aarch64 | Ubuntu | 22 | 22.04.5 | Ubuntu 22.04 ARM | 18 17 16 15 14 | OK |
u24.x86_64 | Ubuntu | 24 | 24.04.4 | Ubuntu 24.04 x86 | 18 17 16 15 14 | OK |
u24.aarch64 | Ubuntu | 24 | 24.04.4 | Ubuntu 24.04 ARM | 18 17 16 15 14 | OK |
u26.x86_64 | Ubuntu | 26 | 26.04.0 | Ubuntu 26.04 x86 | 18 17 16 15 14 | OK |
u26.aarch64 | Ubuntu | 26 | 26.04.0 | Ubuntu 26.04 ARM | 18 17 16 15 14 | OK |
Source
Building specs of these repos and packages are open-sourced on GitHub:
The official PostgreSQL APT/YUM repository
Import the GPG key for Pigsty repository
Packages that are generic to any PostgreSQL version and Linux major version.
The repo for PostgreSQL Extensions & Kernel Forks
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)