Enterprise-grade open-source PostgreSQL distribution with HA, monitoring, 460+ extensions, and Infrastructure as Code for self-hosting.
Pigsty is an open-source PostgreSQL distribution that packages the database with high availability, monitoring, backup, and over 460 extensions into a single platform. It solves the complexity of deploying and managing production-grade PostgreSQL by providing Infrastructure as Code (IaC) templates, self-healing clusters, and integrated observability. Developers can self-host PostgreSQL clusters with enterprise features without relying on expensive cloud-managed services.
Database administrators, DevOps engineers, and developers who need to deploy, manage, and scale PostgreSQL in production environments, especially those seeking cost-effective, self-hosted alternatives to cloud database services.
Pigsty offers a turnkey, battery-included solution that reduces operational overhead by integrating proven tools like Patroni, PgBouncer, and Grafana. Its unique selling point is the combination of extensibility (460+ extensions), declarative IaC, and cloud-neutral design, allowing teams to run PostgreSQL like a pro without vendor lock-in.
Enterprise-Grade OSS PostgreSQL Distribution with HA, PITR, IaC, Monitor, 12 kernel forks and 460 PG extensions. Best-of-breed products integrated as a platform. Self-host Postgres like a Pro!
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Packages 460+ PostgreSQL extensions and 12 kernel forks like Citus and Babelfish, enabling diverse workloads such as sharding, SQL Server compatibility, and time-series data without manual compilation.
Includes Grafana and VictoriaMetrics for monitoring PostgreSQL, infrastructure, and nodes, providing out-of-the-box dashboards and alerts, as shown in the public demo.
Features self-healing HA clusters with automated failover using Patroni and etcd, ensuring RPO near zero and RTO under 30 seconds for production reliability.
Uses Ansible with over 300 declarative parameters for reproducible deployments, supporting one-command setup and templates for complex configurations like Citus sharding.
Designed to run on bare Linux without Docker or Kubernetes, complicating integration with modern containerized workflows and requiring manual server management.
With 300+ configuration parameters and complex Ansible playbooks, initial setup and customization demand significant database and DevOps expertise, as admitted in the documentation.
Heavy reliance on Pigsty's specific toolchain and modules, such as its local repo and monitoring stack, may hinder migration to other platforms without re-engineering.
Pigsty is an open-source alternative to the following products:
Azure Database for PostgreSQL is a fully managed PostgreSQL database service on Microsoft Azure, providing automated management, high availability, and scalability.
A fully-managed relational database service for MySQL, PostgreSQL, and SQL Server on Google Cloud Platform.
Amazon Relational Database Service is a managed SQL database service that supports multiple database engines including MySQL, PostgreSQL, and SQL Server.