jackiedabekar/pods — reverse-engineered prompt

Build me a Docker based PostgreSQL stack called P.O.D.S., Postgres Orchestrated Docker Stack.

I want to run one command and get a primary database plus two read replicas, with streaming replication already working. Put PgBouncer in front so apps can connect to a write database or read databases without knowing the container details. Add a simple script so I can add, remove, list, and check replicas without manually editing config files.

Include a small health API that tells me if the cluster is healthy, whether the primary is up, which replicas are streaming, and if replication is lagging. Add Prometheus and Grafana with a useful dashboard for database status, replication lag, connections, PgBouncer activity, CPU, memory, and container health.

Also add backup and restore commands, with scheduled full backups, WAL archiving, local storage by default, and S3 support if credentials are set. Please include clear setup docs, an env example, and sensible defaults so it works locally with Docker Compose.