下载 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://[email protected]: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://[email protected]:5432/postgres' ./pg_exporter --dry-run

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

全部产物

`.rpm`

下载资产
文件	校验和
pg-exporter-1.6.0-1.aarch64.rpm Linuxarm64SHA-256	`dd81e485377fd9bfead1b3e8000a145eb89d1c914becffaa3588cafc67731ed9`
pg-exporter-1.6.0-1.ppc64le.rpm LinuxSHA-256	`413f64b25feb6202bf7cf70f10d0a73527c42767a2cc2bef37beef6d33ab48ae`
pg-exporter-1.6.0-1.x86_64.rpm Linuxamd64SHA-256	`c25e57077f916a83993263eb0009959bbafe183fb3da4f81169629dfdbd7c64a`

`.deb`

下载资产
文件	校验和
pg-exporter_1.6.0-1_amd64.deb Linuxamd64SHA-256	`46f03078e7e74430c34d3650b48cecacc55e011c6bcecde4f3ef555076f917b3`
pg-exporter_1.6.0-1_arm64.deb Linuxarm64SHA-256	`d24dea8ee5774f28a8e4c5e9c9977b07d80b6e1c4d5a86a7b7802cc5d6d02a0f`
pg-exporter_1.6.0-1_ppc64le.deb LinuxSHA-256	`5cc839bc5f9d551559984442fcd24305e3113688dc2d92d437ed5421683e3ae0`

`.tar.gz`

下载资产
文件	校验和
pg_exporter-1.6.0.darwin-amd64.tar.gz macOSamd64SHA-256	`ddefa112d810bf5ae8acc0eeb9edc23b44609ecd577a75df8f5c2321f81fea47`
pg_exporter-1.6.0.darwin-arm64.tar.gz macOSarm64SHA-256	`a62d9474d091ac906a5fcd1898ffce599eaf74fb7c93800caa85b6c190d64d85`
pg_exporter-1.6.0.linux-amd64.tar.gz Linuxamd64SHA-256	`296a26bf83acd7024f4de8fdeac0ee31baffa01e3153cf5c694e90ed8268719a`
pg_exporter-1.6.0.linux-arm64.tar.gz Linuxarm64SHA-256	`ea6d1dbe0820d599e81ed702e128b4fe4a557e2afb5b5c157de222576c1d7ce7`
pg_exporter-1.6.0.linux-ppc64le.tar.gz LinuxSHA-256	`b720183a3c4d35d20d683bc6ba998e5eddcb1f76e5721788829aa56c2cd7155a`
pg_exporter-1.6.0.windows-amd64.tar.gz Windowsamd64SHA-256	`29909ef65af96f1da5e7258c7b9025c85ad1dca63596c9fba8b85b55e006bb25`

安装 PG Exporter

选择安装方式

`.rpm`

`.deb`

`.tar.gz`