How about an open-source RDS alternative for PostgreSQL?

4 points

3 years ago

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.

* 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.

Features: https://github.com/Vonng/pigsty/blob/master/docs/FEATURE.md

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.

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.

I'm happy to answer any questions about Pigsty ;)