Welcome to Pigsty Doc

Battery-Included Open-Source PostgreSQL Distribution

Latest Version: v1.5.1 | Github Repo | Demo

Documentation: EN Docs | 中文文档 | Github Pages

TBD: CHECK Github Pages FOR LATEST EN DOCS

Overview

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.

Get Started

bash -c "$(curl -fsSL http://download.pigsty.cc/get)"
cd ~/pigsty; ./configure
./infra.yml

About

Pigsty (/ˈpɪɡˌstaɪ/) is the abbreviation of “PostgreSQL In Graphic STYle.”

Author: Vonng (rh@vonng.com)

License: Apache 2.0 License

Overview

What, Why & How

Highlights

pigsty features highlight

Concept

Some key concept & definition in Pigsty

Deployment

Deploy pigsty to your own nodes

Module: INFRA

Infrastructure service module on meta node

Module: NODES

Take more nodes under pigsty’s control。

Module: PGSQL

Provisioning High-Available Postgres Clusters!

Module: REDIS

Provisioning redis clusters in standalone/sentinel/native cluster mode

Monitor

Introduction to pigsty monitoring system

Application

Software, applets, use-cases based Pigsty

Tutorial

Tasks can be explored in pigsty, Common operations & SOP

Reference

Detailed information about pigsty.

Miscellaneous

Subscription & Professional Support. Community & Contribution. License and Roadmap

Last modified 2022-06-20: add timescaledb (3c335f4)