Repository

Pigsty has a repository that provides 200+ extra PostgreSQL extensions on 10 mainstream Linux Distros. It is designed to work together with the official PostgreSQL Global Development Group (PGDG) repo. Together, they can provide up to 423 PostgreSQL Extensions out-of-the-box.

Get Started

You can enable the pigsty infra & pgsql repo with the pig CLI tool, or add them manually to your system:

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
# 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 distribution codename (distro_codename=jammy, focal, bullseye, bookworm), 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
# 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;

All the RPM / DEB packages are signed with GPG Key fingerprint (B9BD8B20) in Pigsty repository.


Compatibility

Pigsty has two major repos: INFRA and PGSQL, provide DEB / RPM 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 utils written in go.

LinuxPackagex86_64aarch64
ELrpm
Debiandeb

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.

OS / ArchOSx86_64aarch64
EL8el8
18
17
16
15
14
18
17
16
15
14
EL9el9
18
17
16
15
14
18
17
16
15
14
Debian 12d12
18
17
16
15
14
18
17
16
15
14
Ubuntu 22.04u22
18
17
16
15
14
18
17
16
15
14
Ubuntu 24.04u24
18
17
16
15
14
18
17
16
15
14
OSVendorMajorMinorFullnamePG Major VersionComment
el7.x86_64
EL77.9CentOS 7 x86
18
17
16
15
14
EOL
el8.x86_64
EL88.10RockyLinux 8 x86
18
17
16
15
14
Near EOL
el8.aarch64
EL88.10RockyLinux 8 ARM
18
17
16
15
14
Near EOL
el9.x86_64
EL99.6RockyLinux 9 x86
18
17
16
15
14
OK
el9.aarch64
EL99.6RockyLinux 9 ARM
18
17
16
15
14
OK
el10.x86_64
EL1010.0RockyLinux 10 x86
18
17
16
15
14
TBD
el10.aarch64
EL1010.0RockyLinux 10 ARM
18
17
16
15
14
TBD
d11.x86_64
Debian1111.11Debian 11 x86
18
17
16
15
14
EOL
d11.aarch64
Debian1111.11Debian 11 ARM
18
17
16
15
14
EOL
d12.x86_64
Debian1212.11Debian 12 x86
18
17
16
15
14
OK
d12.aarch64
Debian1212.11Debian 12 ARM
18
17
16
15
14
OK
d13.x86_64
Debian1313.1Debian 13 x86
18
17
16
15
14
TBD
d13.aarch64
Debian1313.1Debian 13 ARM
18
17
16
15
14
TBD
u20.x86_64
Ubuntu2020.04.6Ubuntu 20.04 x86
18
17
16
15
14
EOL
u20.aarch64
Ubuntu2020.04.6Ubuntu 20.04 ARM
18
17
16
15
14
EOL
u22.x86_64
Ubuntu2222.04.5Ubuntu 22.04 x86
18
17
16
15
14
OK
u22.aarch64
Ubuntu2222.04.5Ubuntu 22.04 ARM
18
17
16
15
14
OK
u24.x86_64
Ubuntu2424.04.3Ubuntu 24.04 x86
18
17
16
15
14
OK
u24.aarch64
Ubuntu2424.04.3Ubuntu 24.04 ARM
18
17
16
15
14
OK

Source

Building specs of these repos and packages are open-sourced on GitHub:

Last updated on