Skip to content

Version v3.7.0 of the documentation is no longer actively maintained. The site that you are currently viewing is an archived snapshot. For up-to-date documentation, see the latest version.

Reference

Architecture, use cases, comparison, etc…

Pigsty (/ˈpɪɡ staɪ/) is a Battery-Included, FOSS PostgreSQL Distribution as a Local-First RDS Alternative.

PostgreSQL Enterprise
    Create self-healing High-Available PG clusters without hassle, with pre-configured Point-In-Time-Recovery, ACL, CA, SSL...
Infrastructure as Code
    Declare your entire infra with code, and setup everything PG needs from Bare OS: LB, Nginx, NTP, DNS, Local Repo, etc...
Stunning Observability
    Unparalleled monitoring best practices built upon modern Prometheus & Grafana observability stacks out-of-the-box
Extensions & Forks
    <span class="text-red-800 font-bold">437</span> PGSQL Extensions battery-included! Alone with forks: Babelfish, Oriole, IvorySQL, OpenHalo, PolarDB, Supabase,...

Pigsty provides everything you’ll need for self-hosting an enterprise-grade PostgreSQL Service even without expertise.

Just use PostgreSQL for EVERYTHING, and Self-Hosting PostgreSQL Like a Pro!

Want to learn more?

Read our in-depth What is Pigsty introduction.

Just use PostgreSQL for Everything! Build data infra with postgres superpowers

Self-hosting PostgreSQL like a Pro! Operate production grade Service without expertise

Pigsty’s modular, declarative infrastructure design for PostgreSQL

How Pigsty compares to cloud RDS, Kubernetes operators, and other PostgreSQL solutions

Available modules in Pigsty

Frequently Asked Questions