Yo, Pigsty is a local-first open-source alternative for RDS PostgreSQL, with monitoring, HA, PITR, IaC, and lots of stuff to run a production-grade PostgreSQL Service on your nodes for free. Demo: http://demo.pigsty.cc.<p>* Battery-Included PostgreSQL Distribution, with PostGIS, TimescaleDB, Citus united as one.
* Incredible observability powered by Prometheus & Grafana stack.
* Self-healing HA PGSQL cluster, powered by patroni, haproxy, etcd…
* Auto-Configured PITR, powered by pgbackrest and optional MinIO cluster
* Declarative API, Database-as-Code implemented with Ansible playbooks.
* Versatile UseCases, Run Docker Apps, Run demos, Visualize data with ECharts panels.
* Install in one command, provision IaaS with Terraform, and test with local Vagrant sandbox.<p>Features: https://github.com/Vonng/pigsty/blob/master/docs/FEATURE.md<p>I'm Vonng, the author of Pigsty and a PostgreSQL DBA of a large deployment (25K cores, 1PB TP data). Pigsty alleviates my pain of managing such a massive elephant in production.<p>It works well for us, and I'm glad to make it open-source. Since cloud RDS PostgreSQL are so expensive, sometimes it charges 10x compared to underlying EC2 and storage. An open-source alternative could help.<p>I'm happy to answer any questions about Pigsty ;)