README

PIGSTY - Self-Host Postgres like a Pro









Enterprise-Grade Open-Source PostgreSQL Distribution with HA, PITR, IaC, Monitor, and 626 PG extensions.

 "PostgreSQL In Great STYle": Postgres, Infras, Graphics, Service, Toolbox, it's all Yours.

Website | ORG | PGEXT | Piglet | Public Demo | Blog | Discuss | Support | Release Notes | 中文



Pigsty scales from laptop to datacenter. Enterprise-grade. Developer-friendly. Get Started with the latest v4.5.0:

bash
curl -fsSL https://repo.pigsty.io/get | bash -s v4.5.0



 Features

- Extensible:   626 PG Extensions & 12 PG Kernels available, Packed for 16 Linux Platforms, Battery-Included.
- Reliable:     Self-healing HA clusters with pre-configured PITR and built-in ACL, CA & SSL secure best practice.
- Observable:   SOTA monitoring for PG / Infra / Node based on the Victoria & Grafana stack: Demo & Gallery.
- Scalable:     Auto-routed & pooled customizable database Services Access with haproxy, pgbouncer, and VIP.
- Maintainable: One-Cmd Deploy, Admin SOP, Auto-Tune, Local Repo, IaC and Vagrant / OpenTofu support, with Terraform compatibility.
- Composable:   Bonus Modules such as Redis / Valkey, MinIO, Etcd, Docker, DuckDB, Supabase, & More.
- Controllable: Self-sufficient Infra Closure, Cloud Neutral FOSS. Run on bare Linux without Docker & K8S.
- Affordable:   Self-Hosting like a Pro, without the cost of RDS. Empowering Cloud-Exit for Ultra Cost Saving!

You can even use many exotic PG Kernel Forks as in-place replacement and wrap it as a full RDS service: 

















|                            Kernel                            |           Key Feature           | Description                                      |
|:------------------------------------------------------------:|:-------------------------------:|:-------------------------------------------------|
|  PostgreSQL  |      Battery-Included       | Original PGDG PostgreSQL with 626 extensions     |
|       Supabase        |     Backend as Service      | BaaS over PostgreSQL, Firebase alternative       |
|      Citus      |     Horizontal Scaling      | Distributive PostgreSQL via native extension     |
|  Babelfish  |    SQL Server Simulation    | Microsoft SQL Server wire-compatibility          |
|   IvorySQL   |      Oracle Simulation      | Oracle Grammar and PL/SQL compatible             |
|   OpenHalo   |      MySQL Simulation       | MySQL wire-protocol compatibility                |
|       DocumentDB        |     MongoDB Simulation      | MongoDB wire-protocol compatibility              |
|    Percona    | Transparent Data Encryption | Percona Distribution with pg_tde                 |
|   OrioleDB   |  OLTP Optimization Engine   | No bloat, No XID Wraparound, S3 Storage          |
|    PolarDB    |      Aurora flavor RAC      | RAC, China domestic compliance                   |
| AgensGraph |    Graph-Native Database    | Transactional graph database based on PostgreSQL |
|     pgEdge     |  Multi-Master Distributive  | G