v1.1.1

postgresql // watchdog

Connection
watchdog

Monitor active and idle connections, detect stale sessions, and alert via Slack or Loki — self-hosted Go CLI.

$ curl -fsSL https://get.pgwd.hermesrodriguez.com/install.sh | sh
$ pgwd --print-sample-config > ./pgwd.conf  # adjust
$ pgwd -config ./pgwd.conf -dry-run -interval 0
curl -fsSL https://get.pgwd.hermesrodriguez.com/install.sh | sh
Install pgwdReleases

Connection monitoring

Thresholds for active/idle counts and stale sessions — configured in YAML or environment, not ad-hoc SQL scripts.

Alerting

Slack webhooks and Loki push when limits are exceeded — optional quiet modes for cron.

Operator-grade

Signed releases, packages for Linux/BSD, Helm and Compose paths in pgwd-selfhosted — built for DBAs and SREs.

pgwd at a glance

pgwd v1.1.1 product infographic

Quick start

Operator examples: pgwd-selfhosted/run

Recent releases

v1.1.12026-08-31

Security
  • Go toolchain 1.26.6 (stdlib CVE fixes)
  • Transitive golang.org/x/net v0.56.0 (GO-2026-5942); GHCR image passes Grype --fail-on high

v1.1.02026-08-10

On-call
  • PagerDuty: stable dedup_key and event_action resolve on recovery
  • Threshold alerts quiet by default (repeat_while_firing to restore per-interval spam)

v1.0.02026-07-18

Stable
  • Stable API: removed legacy db:, total/active thresholds, and notify_on_connect_failure
  • Exit codes 2 and 3 documented; Cosign v3 checksum signing bundle
  • Operator docs: UPGRADE-0.9-to-1.0, compare.md, postgresql-connection-limits.md

Engineering report v1.1.1 · Full changelog on GitHub

Repositories

RepoRole
hrodrig/pgwdCLI, releases, container image, README
hrodrig/pgwd-selfhostedDocker Compose, Helm, cron, examples