Pigsty Package Repo

The supplementary apt and yum software repo for PostgreSQL ecosystem used by Pigsty

Contains 150+ PG extensions for PostgreSQL 12 - 17 in addition to the official PGDG apt/yum repo.

Related Projects:

• infra_pkg: Building observability stack & modules from tarball
• pgsql-rpm: Building PostgreSQL RPM packages from source code
• pgsql-deb: Building PostgreSQL DEB packages from source code

---

Pigsty

You can install pigsty source from this repo, via:

# install the latest pigsty version
curl -fsSL https://repo.pigsty.io/get | bash

# install a specific version
curl -fsSL https://repo.pigsty.io/get | bash -s v3.0.3

---

YUM Repo

Pigsty currently offers a supplementary PG extension repository for EL systems, providing 121 additional RPM plugins in addition to the official PGDG YUM repository (135).

• Pigsty YUM Repository: https://repo.pigsty.io/yum/
• PGDG YUM Repository: https://download.postgresql.org/pub/repos/yum/

The Pigsty YUM repository only includes extensions not present in the PGDG YUM repository. Once an extension is added to the PGDG YUM repository, Pigsty YUM repository will either remove it or align with the PGDG repository.

For EL 7/8/9 and compatible systems, use the following commands to add the GPG public key and the upstream repository file of the Pigsty repository:

curl -fsSL https://repo.pigsty.io/key      | sudo tee /etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty >/dev/null  # add gpg key
curl -fsSL https://repo.pigsty.io/yum/repo | sudo tee /etc/yum.repos.d/pigsty.repo        >/dev/null  # add repo file

All RPMs are signed with the GPG key fingerprint 9592A7BC7A682E7333376E09E7935D8DB9BD8B20 (B9BD8B20).

Write Repo File Manually

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
sudo yum makecache;

---

APT Repo

Pigsty currently offers a supplementary PG extension repository for Debian/Ubuntu systems, providing 133 additional DEB packages in addition to the official PGDG APT repository (109).

• Pigsty APT Repository: https://repo.pigsty.io/apt/
• PGDG APT Repository: http://apt.postgresql.org/pub/repos/apt/

The Pigsty APT repository only includes extensions not present in the PGDG APT repository. Once an extension is added to the PGDG APT repository, Pigsty APT repository will either remove it or align with the PGDG repository.

For Debian/Ubuntu and compatible systems, use the following commands to sequentially add the GPG public key and the upstream repository file of the Pigsty repository:

# add GPG key to keyring
curl -fsSL https://repo.pigsty.io/key | sudo gpg --dearmor -o /etc/apt/keyrings/pigsty.gpg

# get debian codename, distro_codename=jammy, focal, bullseye, bookworm
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 repo cache
sudo apt update

All DEBs are signed with the GPG key fingerprint 9592A7BC7A682E7333376E09E7935D8DB9BD8B20 (B9BD8B20).

---

What's inside?

Prepacked RPM & DEB binary packages for the following software.

Observability Stack:

• grafana : 11.1.4
• loki : 3.1.1
• promtail : 3.0.0 (buggy 3.1.0)
• prometheus : 2.54.0
• pushgateway : 1.9.0
• alertmanager : 0.27.0
• blackbox_exporter : 0.25.0
• nginx_exporter : 1.2.0
• node_exporter : 1.8.2
• keepalived_exporter : 0.7.0
• pg_exporter : 0.7.0
• pgbackrest_exporter 0.18.0
• mysqld_exporter : 0.15.1
• redis_exporter : v1.62.0
• kafka_exporter : 1.8.0
• mongodb_exporter : 0.40.0
• VictoriaMetrics : 1.102.1
• VictoriaLogs : v0.28.0
• vector : 0.40.0

Database Modules:

• duckdb : 1.0.0
• etcd : 3.5.15
• redis 7.2.5
• minio: 20240817012454
• mcli: 20240817113350
• sealos: 5.0.0
• ferretdb: 1.23.1
• paradedb: pg_search 0.10.2, pg_analytics 0.1.4
• tigerbeetle: 0.15.6
• cloudberrydb: 1.5.4

PostgreSQL Tools:

• vip-manager: 2.6.0
• pg_timetable: 5.9.0
• scws: 1.2.3, deps of zhparser
• libduckdb : 1.0.0, deps of duckdb_fdw
• libarrow-s3 : 17.0.0, deps of parquet_s3_fdw

PostgreSQL Extensions:

• All Other PostgreSQL 16 Extensions for el8, el9, debian12, and ubuntu22.

---

Supported Distros

Observability Stack (the infra module) runs on any Linux distro.

While others (the pgsql module) are supported on the following distros:

• el9.x86_64: ⭐️ RockyLinux 9.3, and other compatible distros
• d12.x86_64: ⭐️ Debian 12 bookworm, and other compatible distros
• u22.x86_64: ⭐️ Ubuntu 22.04.3 jammy, and other compatible distros
• el8.x86_64: ⭐️ RockyLinux 8.9, and other compatible distros

We may drop legacy support for the following distros in the future due to EOL:

• el7.x86_64: CentOS 7.9, and other compatible distros
• d11.x86_64: Debian 11 bullseye, and other compatible distros
• u20.x86_64: Ubuntu 20.04 focal, and other compatible distros

---

License

Maintainer: Ruohang Feng / @Vonng ([email protected])

License: Apache 2.0