Colors

package-postgres-agy-green

Clojure / Babashka

Build and operate a three-node PostgreSQL 17 failover cluster on DigitalOcean with Patroni, colocated etcd v3, HAProxy client routing, Cloudflare DNS, pgBackRest backups to Cloudflare R2, heartbeat streaming, and verified restore check.

Installation
npx skills add https://github.com/getcolors/postgres-agy --skill package-postgres-agy-green

SKILL.md

PostgreSQL 17 High Availability on DigitalOcean

Read colors.yml before changing desired state or running a lifecycle command.

Safety

  • Keep secrets out of colors.yml; use gitignored COLORS_PAR_* exports.
  • Never set COLORS_PAR_PROFILE and never edit generated .colors/ files.
  • Default to build and create --dry-run; real create/delete needs explicit authorization.
  • Keep compute-prevent-destroy: true. Lift it for one authorized delete with COLORS_PAR_COMPUTE_PREVENT_DESTROY=false.
  • Restrict digitalocean-ssh-sources and digitalocean-client-sources; do not use 0.0.0.0/0.

Commands

./green build
./green create --dry-run
./green create
./green status
./green switchover
./green backup
./green verify-restore
./green psql
./green delete