PIGSTY - Self-Host Postgres like a Pro

Enterprise-Grade Open-Source PostgreSQL Distribution with HA, PITR, IaC, Monitor, and 575 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:

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

Features

• Extensible: 575 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:

And gather the synergistic superpowers of all 575 PostgreSQL Extensions all together:

Get Started

Prepare a fresh x86_64 / aarch64 node runs any compatible Linux OS Distros, then Install Pigsty with:

curl -fsSL https://repo.pigsty.io/get | bash; cd ~/pigsty;

Then configure and run the deploy.yml playbook with an admin user (nopass `ssh