pgsty/pigsty — reverse-engineered prompt

Build me a self hosted Postgres platform from this repo that feels like a simple private RDS I can run on my own Linux machines.

I want a clean one command setup that provisions a secure PostgreSQL cluster, turns on backups, lets me restore to a point in time, sets up failover, connection pooling, access routing, certificates, and sensible defaults. Include monitoring dashboards for Postgres, servers, and infrastructure so I can quickly see health, slow queries, storage, replication, and alerts.

Make common admin jobs easy, like adding databases and users, changing access rules, running maintenance, checking backups, and deploying extra modules such as Redis, MinIO, Docker apps, or Supabase when the repo supports them. It should work for a laptop demo but also be clear enough to expand to multiple machines later.

Please wire up the existing scripts, playbooks, templates, and config instead of inventing a new product. Look up the current Pigsty docs online if you need to.