Repository
PGSQL Repo

PGSQL Repo

The pigsty-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.

You can check the Release - RPM Chanagelog / Release - DEB Chanagelog for the latest updates.

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 d12
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

Quick Start

PIG

You can install pig - the cli tool, and add pgdg / pigsty repo with it (recommended):

pig repo add pigsty                         # add pigsty-pgsql repo
pig repo add pigsty -u                      # add pigsty-pgsql repo, and update cache
pig repo add pigsty -u --region=default     # add pigsty-pgsql repo and enforce default region (pigsty.io)
pig repo add pigsty -u --region=china       # add pigsty-pgsql repo with china region   (pigsty.cc)
pig repo add pgsql -u                       # pgsql = pgdg + pigsty-pgsql (add pigsty + official PGDG)
pig repo add -u                             # all = node + pgsql (pgdg + pigsty) + infra

APT

You can also enable this repo with apt directly on Debian / Ubuntu:

# 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/pgsql/${distro_codename} ${distro_codename} main
EOF

# Refresh APT repository cache
sudo apt update

DNF

You can also enable this repo with dnf/yum directly on EL-compatible systems:

# 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-pgsql.repo > /dev/null <<-'EOF'
[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 dnf makecache;

Source

Building specs of this repo is open-sourced on GitHub:

If the platform is not supported, you can also build the packages from source code by yourself.

The pig build provide an easy way to build extension rpm/deb on your own systems.

Last updated on
INFRA Repo