APT Repo

You can use the following Shell commands to manually add the Pigsty repository GPG key, write the repository definition, and update the cache.

The default repo.pigsty.io repository is hosted on Cloudflare CDN, which may be slow for users in mainland China. You can use the China CDN mirror site repo.pigsty.cc instead of the default repo.pigsty.io repository:

Add Repo

For Debian/Ubuntu and compatible systems, use the following commands to add the Pigsty repository GPG key, write the repository definition, and update the cache:

• Pigsty APT Repo
• Cloudflare
• China CDN

# 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} 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.cc/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.cc/apt/infra generic main
deb [signed-by=/etc/apt/keyrings/pigsty.gpg] https://repo.pigsty.cc/apt/pgsql/${distro_codename} ${distro_codename} main
EOF

# Refresh APT repository cache
sudo apt update

Repo Content

The pigsty-pgsql repository contains:

• 208 PostgreSQL extension RPM packages (maintained by Pigsty, not included in PGDG YUM repository)
• 215 PostgreSQL extension DEB packages (maintained by Pigsty, not included in PGDG APT repository)
• haproxy 3.1
• redis 7.2

The pigsty-infra repository contains:

• etcd : 3.5.18
• duckdb : 1.2.0
• ferretdb: 2.0.0-rc1
• pg_timetable: 5.11.0
• grafana : 11.5.2
• prometheus : 3.1.0
• pushgateway : 1.11.0
• alertmanager : 0.28.0
• blackbox_exporter : 0.25.0
• nginx_exporter : 1.4.1
• node_exporter : 1.8.2
• keepalived_exporter : 1.4.0
• pgbackrest_exporter 0.19.0
• mysqld_exporter : 0.16.0
• redis_exporter : 1.67.0
• kafka_exporter : 1.8.0
• mongodb_exporter : 0.43.1
• VictoriaMetrics : 1.111.0
• VictoriaLogs : 1.9.1
• tigerbeetle 0.16.27
• loki : 3.1.1
• promtail : 3.0.0 (3.1.1 fail on el7/el8)