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. See the extension catalog for each extension’s source, version, and platform coverage. Together, these repositories provide 600 packaged PostgreSQL extensions.
| PGSQL Repo | Description | Link |
|---|---|---|
| PGSQL Repo | Pigsty Extension Repo, extensions and kernel variants | 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 |
Repository Modules in Pigsty
repo_modules and node_repo_modules select repositories by the module field in roles/node_id/vars/<os>.<arch>.yml. Development versions use nginx and docker for the corresponding upstream repositories. In the v4.5.0 release, Docker and Nginx on EL still belong to infra.
Add these modules explicitly when needed, for example node_repo_modules: node,infra,pgsql,nginx,docker. The local offline repository uses local. See REPO and node_repo_modules for the full parameters.
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)