下载 PG Exporter

适合 Linux 服务。软件包包含程序、采集器配置、systemd 单元与 /etc/default/pg_exporter，使用 APT 或 YUM 升级。

sudo apt update
sudo apt install -y curl gnupg
sudo install -d -m 0755 /etc/apt/keyrings
curl -fsSL https://repo.pigsty.io/key | gpg --dearmor | sudo tee /etc/apt/keyrings/pigsty.gpg >/dev/null
sudo chmod 0644 /etc/apt/keyrings/pigsty.gpg
sudo tee /etc/apt/sources.list.d/pigsty-infra.list > /dev/null <<'EOF'
deb [signed-by=/etc/apt/keyrings/pigsty.gpg] https://repo.pigsty.io/apt/infra generic main
EOF

sudo apt update
sudo apt install -y pg-exporter

curl -fsSL https://repo.pigsty.io/key | sudo tee /etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty >/dev/null
sudo tee /etc/yum.repos.d/pigsty-infra.repo > /dev/null <<-'EOF'
[pigsty-infra]
name=Pigsty Infra for $basearch
baseurl=https://repo.pigsty.io/yum/infra/$basearch
enabled = 1
gpgcheck = 1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty
module_hotfixes=1
EOF

sudo yum makecache
sudo yum install -y pg-exporter

# PG_EXPORTER_URL='postgres://monitor@127.0.0.1:5432/postgres?sslmode=disable'
sudoedit /etc/default/pg_exporter

sudo systemctl enable --now pg_exporter
curl -fsS http://127.0.0.1:9630/up

下载指定版本的 RPM 或 DEB，用于离线安装或固定版本升级。安装后按软件包一栏配置并启动服务。

RPM / DEB

# Choose amd64, arm64, or ppc64le for this host.
ARCH=amd64
curl -fLO "https://github.com/pgsty/pg_exporter/releases/download/v1.6.0/pg-exporter_1.6.0-1_$ARCH.deb"
sudo apt install "./pg-exporter_1.6.0-1_$ARCH.deb"

ARCH=$(uname -m)
curl -fLO "https://github.com/pgsty/pg_exporter/releases/download/v1.6.0/pg-exporter-1.6.0-1.$ARCH.rpm"
sudo dnf install "./pg-exporter-1.6.0-1.$ARCH.rpm"

适合独立运行。Linux 提供 amd64、arm64 和 ppc64le，macOS 提供 amd64 和 arm64， Windows 提供 amd64。下方命令用于 Linux 或 macOS；macOS 请设置 OS=darwin， ARM64 设置 ARCH=arm64，x86-64 设置 ARCH=amd64。校验命令输出 OK 后再解压。

(
  set -e
  OS=linux ARCH=amd64
  ARCHIVE="pg_exporter-1.6.0.$OS-$ARCH.tar.gz"

  curl -fLO "https://github.com/pgsty/pg_exporter/releases/download/v1.6.0/$ARCHIVE"
  curl -fLO "https://github.com/pgsty/pg_exporter/releases/download/v1.6.0/checksums.txt"
  if command -v sha256sum >/dev/null 2>&1; then
    grep "  $ARCHIVE$" checksums.txt | sha256sum -c -
  else
    grep "  $ARCHIVE$" checksums.txt | shasum -a 256 -c -
  fi
  mkdir -p stage && tar -xzf "$ARCHIVE" -C stage
  sudo install -m 0755 stage/pg_exporter /usr/local/bin/pg_exporter
  sudo install -m 0644 stage/pg_exporter.yml /etc/pg_exporter.yml

  pg_exporter --version
)

多架构 amd64/arm64 镜像。它基于 scratch 构建，包含静态二进制、合并配置、许可证与系统 CA 证书，没有 shell；使用私有 CA 时仍需挂载证书并设置 sslrootcert。将示例 URL 中的 postgres 替换为容器可达的数据库主机名，并设置监控凭据。

容器

docker run -d \
  --name pg_exporter \
  --restart unless-stopped \
  -p 127.0.0.1:9630:9630 \
  -e PG_EXPORTER_URL='postgres://monitor:S3cret@postgres:5432/postgres' \
  pgsty/pg_exporter:1.6.0

curl -fsS http://127.0.0.1:9630/up

docker run -d \
  --name pg_exporter \
  --restart unless-stopped \
  -p 127.0.0.1:9630:9630 \
  -e PG_EXPORTER_URL_FILE=/run/secrets/pgurl \
  -v ./pgurl:/run/secrets/pgurl:ro \
  -v ./pg_exporter.yml:/etc/pg_exporter.yml:ro \
  pgsty/pg_exporter:1.6.0

Pigsty 将 PG Exporter 与指标存储、告警规则和 Grafana 仪表盘一起部署。下载 Pigsty 后，按其安装指南配置清单并部署监控栈。

Pigsty

curl -fsSL https://repo.pigsty.io/get | bash
cd ~/pigsty

适用于开发与自定义编译参数。按标签构建后，参考部署指南配置服务账号与 systemd 单元。

源码

git clone https://github.com/pgsty/pg_exporter.git
cd pg_exporter
git checkout "v1.6.0"
make build

./pg_exporter --version
PG_EXPORTER_URL='postgres://monitor@127.0.0.1:5432/postgres' ./pg_exporter --dry-run

发布压缩包、软件包及其 SHA-256 摘要。在 macOS 上使用 shasum -a 256 <文件> 与对应条目比对。

全部产物

`.rpm`

下载资产
文件	校验和
pg-exporter-1.6.0-1.aarch64.rpm Linuxarm64SHA-256	`1bb4bfeb40f215a6ad3998d4399b12074bacfe03920a38784599b04eb1ca3028`
pg-exporter-1.6.0-1.ppc64le.rpm LinuxSHA-256	`87b248e8eab5e872146c63e7c8fff86eb8f4dcd4db5505957aff2e17043bd3a2`
pg-exporter-1.6.0-1.x86_64.rpm Linuxamd64SHA-256	`955ee5549aebc347fa1bd4e0517812c687d037faf17054a678fbc5bfffc4eb03`

`.deb`

下载资产
文件	校验和
pg-exporter_1.6.0-1_amd64.deb Linuxamd64SHA-256	`448c9dfc738e1425ace8cafdf44bbc677c2aee21fb89ec49faec5a8d6b3c35ef`
pg-exporter_1.6.0-1_arm64.deb Linuxarm64SHA-256	`e10a3823b2fb30c44eba1d6b1f833af3244a2451221c8d65071eaad32673c001`
pg-exporter_1.6.0-1_ppc64le.deb LinuxSHA-256	`61bc7efd5ac9a7a3bef2860a67bfa1ee0b379a09e85389ca75306aec3dee209a`

`.tar.gz`

下载资产
文件	校验和
pg_exporter-1.6.0.darwin-amd64.tar.gz macOSamd64SHA-256	`f7a57acb1ccd9fd074e6a41a8811ae0fc482a7d8db34aec508415ff0ee93f5b2`
pg_exporter-1.6.0.darwin-arm64.tar.gz macOSarm64SHA-256	`6c8e475ba675fa86921c07e5031db8073ddd012f198e88f66548be0d246baab7`
pg_exporter-1.6.0.linux-amd64.tar.gz Linuxamd64SHA-256	`e392328ca27fd7a84e3273f2cfe70d28d2e7f162dcc735fb9fb96182368a59e3`
pg_exporter-1.6.0.linux-arm64.tar.gz Linuxarm64SHA-256	`3795371d53388757778eea180ea91e71e51945a4864ccef315a93a230d8729fe`
pg_exporter-1.6.0.linux-ppc64le.tar.gz LinuxSHA-256	`ec2b7c7419a6f111494ccc777cfb86825e421b0f494aa68623e05e3c31d681f4`
pg_exporter-1.6.0.windows-amd64.tar.gz Windowsamd64SHA-256	`92fc6b5e58fcaa120473f59856874b8a44ea0e7388d417c5de0fbc709d6687f2`

安装 PG Exporter

选择安装方式

`.rpm`

`.deb`

`.tar.gz`