Linux Repository
The Pigsty repository provides additional PostgreSQL extension packages for mainstream Linux distributions. Use it with the official PostgreSQL Global Development Group (PGDG) repository. Together, these repositories provide 600 packaged PostgreSQL extensions.
| 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
Use the pig CLI tool to enable the Pigsty infra and pgsql repositories:
Manual Install
You can also add these repositories manually with the standard apt, dnf, or yum tools.
Pigsty signs all RPM / DEB packages in its repository with the GPG key identified by B9BD8B20.
Repository Components
Pigsty has two main repositories: INFRA and PGSQL. They provide DEB / RPM packages for x86_64 and aarch64.
The INFRA repository contains packages that are independent of the PostgreSQL version and Linux major version. These include the Prometheus and Grafana stack, PostgreSQL administration tools, and many utilities written in Go.
| Linux | Package | x86_64 | aarch64 |
|---|---|---|---|
| EL | rpm | ✓ | ✓ |
| Debian | deb | ✓ | ✓ |
The PGSQL repository contains packages for specific PostgreSQL major versions. These packages often also depend on the Linux distribution major version. They include 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
The build specifications for these repositories and packages are open source 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)