PigstyA batteries-included PostgreSQL distribution

Local-first · Open-source · Production-grade alternative to managed RDS

PostgreSQL at the Core

A complete distribution built on PostgreSQL 17 with 340+ extensions — OLTP, OLAP, time-series, geo, vector, graph, document workloads all on one engine.

Module catalog

🔋

Self-healing HA

Automatic failover with Patroni + etcd; seamless read/write routing via HAProxy and VIP; point-in-time recovery with pgBackRest.

HA architecture

📈

Observability Built-in

Full-stack monitoring with Prometheus, Grafana, VictoriaMetrics and Loki — 30+ preconfigured dashboards and 600+ metrics.

Monitoring guide

🧩

Modular Ecosystem

PGSQL, REDIS, MINIO, ETCD, FERRET, DOCKER, VIBE, JUICE — mix and match modules; one infrastructure hosts many data services.

Modules

🛡️

Security & Compliance

TLS, certificate authority, password policy, audit logging, least-privilege model on by default; offline install for air-gapped and compliance environments.

Security hardening

⚡

IaC & Bulk Operations

One declarative YAML describes the entire database infrastructure; Ansible playbooks cover install, scale, failover, backup and restore.

Production deployment

Why Pigsty

Pigsty (Postgres In Great STYle) is an open-source, free, production-ready PostgreSQL distribution. It bundles the database, monitoring, high availability, backup, connection pooling and extension ecosystem into an infrastructure stack that runs entirely on your own machines — delivering an RDS-grade experience locally, without vendor lock-in.

A single command bootstraps the whole stack on a 1C/2G Linux box:

bash

curl -fsSL https://repo.pigsty.cc/get | bash -s v4.2.2

Learning Path

Introduction — what Pigsty is, what it does, who it's for
Getting Started — install, configure, connect, back up, monitor
Advanced — multi-node deployment, HA, security, templates
Modules — deep dives into PGSQL, INFRA, REDIS, MINIO, …
Reference — parameters, metrics, extensions, FAQ

Common Scenarios

Pigsty is widely used in — see the scenario index →