Product Information
What is Pigsty?
Battery-included, local-first, open-source PostgreSQL RDS alternative.
Features
Battery-included PostgreSQL distribution with over 150 optional extensions.
Incredible observability powered by Prometheus and Grafana stack.
Self-healing HA PGSQL clusters, backed by Patroni, HAProxy, and etcd. Auto-tuning included.
Auto-configured PITR, supported by pgBackRest with optional MinIO repository (or S3/FS).
Declarative API, Database-as-Code implemented using Ansible playbooks: SOP.
Convenient IaC templates, provisioning infrastructure with Terraform and experimenting in a Vagrant sandbox.
Pre-packaged stable releases, creating local repositories and installing without internet access.
How to use Pigsty?
Pigsty is an out-of-the-box, local-first, open-source PostgreSQL distribution, serving as an alternative to RDS by providing everything needed for production-grade PostgreSQL deployments.
Core Functions of Pigsty
Platform as a Service
PostgreSQL support
Database as a Service
Docker support
High availability
Usage Scenarios of Pigsty
- Create self-healing, highly available PostgreSQL clusters
- Quickly deploy database infrastructure with declarative APIs and Ansible Playbooks
- Monitor existing database management systems and cloud RDS
- Self-host services like Supabase, MinIO, Etcd, and Redis
- Offline installation of PostgreSQL and extensions in network-free environments
- Suitable for data analysis, AI applications, geospatial, time-series data, and text search scenarios
Common Questions about Pigsty
What does Pigsty do?
How do I use Pigsty?
What are the core features of Pigsty?
What are the use cases for Pigsty?
