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
• rpm: Building PostgreSQL RPM packages from source code
• deb: Building PostgreSQL DEB packages from source code

The complete 341 Extension List

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.2.0

You can install pigsty cli - pig with

curl -fsSL https://repo.pigsty.io/pig | bash
curl -fsSL https://repo.pigsty.cc/pig | bash  # mirror

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

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

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;

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:

curl -fsSL https://repo.pigsty.io/key | sudo gpg --dearmor -o /etc/apt/keyrings/pigsty.gpg  # add gpg key
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/$(lsb_release -cs) $(lsb_release -cs) main
EOF
sudo apt update

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

Prepacked RPM & DEB binary packages for the following software.

Observability Stack:

• prometheus : 3.0.1
• pushgateway : 1.10.0
• alertmanager : 0.27.0
• blackbox_exporter : 0.25.0
• nginx_exporter : 1.4.0
• node_exporter : 1.8.2
• keepalived_exporter : 1.4.0
• pgbackrest_exporter 0.18.0
• mysqld_exporter : 0.16.0
• redis_exporter : v1.66.0
• kafka_exporter : 1.8.0
• mongodb_exporter : 0.43.0
• VictoriaMetrics : 1.107.0
• VictoriaLogs : v1.3.2
• pg_timetable: 5.10.0
• ferretdb: 1.24.0
• tigerbeetle 0.16.13
• loki : 3.1.1
• promtail : 3.0.0 (3.1.1 fail on el7/el8)
• vector : 0.43.1
• pg_exporter : 0.7.1 (Maintained Separately)

Database Modules:

• duckdb : 1.1.3
• etcd : 3.5.17
• redis 7.2.6
• minio: 20241213221912
• mcli: 20241121172154
• sealos: 5.0.1
• ferretdb: 1.24.0
• paradedb: pg_search 0.13.2, pg_analytics 0.2.4
• tigerbeetle: 0.16.17
• cloudberrydb: 1.6.0

PostgreSQL Tools:

• vip-manager: 3.0.0
• pg_timetable: 5.10.0
• scws: 1.2.3, deps of zhparser
• libduckdb : 1.1.2, deps of duckdb_fdw
• promscale 0.17.0

PostgreSQL Extensions:

• PostgreSQL 12-17 Extensions for el8, el9, debian12, and ubuntu22.
• check the Extension List for details.

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

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

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

License: Apache 2.0