Skip to content

Linux Repository

The APT / DNF repository to deliver PostgreSQL Kernel, Extensions and Infra packages.

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 RepoDescriptionLink
PGSQL RepoPigsty Extension Repo, supplementary extension packagespgsql.md
INFRA RepoPigsty Infrastructure Repo, monitoring/toolsinfra.md
PGDG RepoPGDG Official Repo Mirror, PG Kernelpgdg.md
GPG KeyGPG Public Key, signature verificationgpg.md

Compatibility Overview

OS / ArchOSx86_64aarch64
EL8el818, 17, 16, 15, 1418, 17, 16, 15, 14
EL9el918, 17, 16, 15, 1418, 17, 16, 15, 14
EL10el1018, 17, 16, 15, 1418, 17, 16, 15, 14
Debian 12d1218, 17, 16, 15, 1418, 17, 16, 15, 14
Debian 13d1318, 17, 16, 15, 1418, 17, 16, 15, 14
Ubuntu 22.04u2218, 17, 16, 15, 1418, 17, 16, 15, 14
Ubuntu 24.04u2418, 17, 16, 15, 1418, 17, 16, 15, 14
Ubuntu 26.04u2618, 17, 16, 15, 1418, 17, 16, 15, 14

Get Started

Use the pig CLI tool to enable the Pigsty infra and pgsql repositories:

Default
curl https://repo.pigsty.io/pig | bash      # download and install the pig CLI tool
pig repo add all -u                         # add linux, pgdg, pigsty repo and update cache
Mirror
curl https://repo.pigsty.cc/pig | bash      # download from mirror site
pig repo add -u                             # add linux, pgdg, pigsty repo and update cache

Manual Install

You can also add these repositories manually with the standard apt, dnf, or yum tools.

APT
# Add Pigsty's GPG public key to your system keychain to verify package signatures
curl -fsSL https://repo.pigsty.io/key | sudo gpg --dearmor -o /etc/apt/keyrings/pigsty.gpg

# Get Debian / Ubuntu distribution codename (bookworm, trixie, jammy, noble, resolute), and write the corresponding upstream repository address to the APT List file
distro_codename=$(lsb_release -cs)
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/${distro_codename} ${distro_codename} main
EOF

# Refresh APT repository cache
sudo apt update
YUM
# Add Pigsty's GPG public key to your system keychain to verify package signatures
curl -fsSL https://repo.pigsty.io/key | sudo tee /etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty >/dev/null

# Add Pigsty Repo definition files to /etc/yum.repos.d/ directory, including two repositories
sudo tee /etc/yum.repos.d/pigsty-io.repo > /dev/null <<-'EOF'
[pigsty-infra]
name=Pigsty Infra for $basearch
baseurl=https://repo.pigsty.io/yum/infra/$basearch
skip_if_unavailable = 1
enabled = 1
priority = 1
gpgcheck = 1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty
module_hotfixes=1

[pigsty-pgsql]
name=Pigsty PGSQL For el$releasever.$basearch
baseurl=https://repo.pigsty.io/yum/pgsql/el$releasever.$basearch
skip_if_unavailable = 1
enabled = 1
priority = 1
gpgcheck = 1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty
module_hotfixes=1
EOF

# Refresh YUM/DNF repository cache
sudo yum makecache;

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.

LinuxPackagex86_64aarch64
ELrpm✓✓
Debiandeb✓✓

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 CodeVendorMajorMinorFullnamePG Major VersionComment
el7.x86_64EL77.9CentOS 7 x8615 14 13EOL
el8.x86_64EL88.10RockyLinux 8 x8618 17 16 15 14Near EOL
el8.aarch64EL88.10RockyLinux 8 ARM18 17 16 15 14Near EOL
el9.x86_64EL99.8RockyLinux 9 x8618 17 16 15 14OK
el9.aarch64EL99.8RockyLinux 9 ARM18 17 16 15 14OK
el10.x86_64EL1010.2RockyLinux 10 x8618 17 16 15 14OK
el10.aarch64EL1010.2RockyLinux 10 ARM18 17 16 15 14OK
d11.x86_64Debian1111.11Debian 11 x8617 16 15 14 13EOL
d11.aarch64Debian1111.11Debian 11 ARM17 16 15 14 13EOL
d12.x86_64Debian1212.15Debian 12 x8618 17 16 15 14OK
d12.aarch64Debian1212.15Debian 12 ARM18 17 16 15 14OK
d13.x86_64Debian1313.6Debian 13 x8618 17 16 15 14OK
d13.aarch64Debian1313.6Debian 13 ARM18 17 16 15 14OK
u22.x86_64Ubuntu2222.04.5Ubuntu 22.04 x8618 17 16 15 14OK
u22.aarch64Ubuntu2222.04.5Ubuntu 22.04 ARM18 17 16 15 14OK
u24.x86_64Ubuntu2424.04.4Ubuntu 24.04 x8618 17 16 15 14OK
u24.aarch64Ubuntu2424.04.4Ubuntu 24.04 ARM18 17 16 15 14OK
u26.x86_64Ubuntu2626.04.0Ubuntu 26.04 x8618 17 16 15 14OK
u26.aarch64Ubuntu2626.04.0Ubuntu 26.04 ARM18 17 16 15 14OK

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?