What, Why & How
Welcome to Pigsty Doc
Battery-Included Open-Source PostgreSQL Distribution
TBD: CHECK Github Pages FOR LATEST EN DOCS
Pigsty is battery-included open-source database distribution, with the latest PostgreSQL kernel, TimescaleDB, PostGIS, Citus & 100+ extensions, along with an entire Infra: Grafana, Prometheus, Loki, Ansible, Docker to support your databases & applications. It also includes common tools for data analysis.
Pigsty is a monitoring & management SRE Solution. Which includes an unparalleled monitoring system with ultimate observability, and high-available PostgreSQL with self-healing architecture. You can deploy various clusters & instances: primary, replica, standby, offline, delayed, cascade, and even Citus, Redis, and Greenplum clusters.
Pigsty is a handy toolbox for developers. It treats Infra as Code, Database as Data. Just describe what database you want, and pigsty will create it for you. You can download, install, deploy, scale, backup, migration with one command. It can be deployed everywhere: a 10k+ core prod env or local 1C/2G VM, cloud, or on-premises.
Pigsty is a secure & thrifty alternative to Cloud RDS/PaaS. It can empower a single DEV/DBA to manage hundreds of databases clusters, with all data under your own control. It can save 50% - 80% cost compared to cloud RDS using ECS or on-premise deployment. And the software itself is completely open-source & free!
Check FEATURES for more detail.
bash -c "$(curl -fsSL http://download.pigsty.cc/get)" cd ~/pigsty; ./configure ./infra.yml
Pigsty (/ˈpɪɡˌstaɪ/) is the abbreviation of “PostgreSQL In Graphic STYle.”
License: Apache 2.0 License
pigsty features highlight
Some key concept & definition in Pigsty
Deploy pigsty to your own nodes
Infrastructure service module on meta node
Take more nodes under pigsty’s control。
Provisioning High-Available Postgres Clusters!
Provisioning redis clusters in standalone/sentinel/native cluster mode
Introduction to pigsty monitoring system
Software, applets, use-cases based Pigsty
Tasks can be explored in pigsty, Common operations & SOP
Detailed information about pigsty.
Subscription & Professional Support. Community & Contribution. License and Roadmap
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.