Battery-Included, Local-First PostgreSQL Distribution as a Free & Better RDS!
"PostgreSQL In Great STYle": Postgres, Infras, Graphics, Service, Toolbox, it's all Yours.
Website | ORG | PGEXT.CLOUD | PG.CENTER | AI INFRA | Public Demo | Blog | Discuss | Support | 中文站 | 博客
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.0The things you actually run.
| Repo | What it is | Docs | ★ |
|---|---|---|---|
| pigsty | The distribution — HA, PITR, IaC, monitoring, 12 kernel forks, 575 extensions | pigsty.io |  |
| silo | S3-compatible object storage — the community MinIO fork, still Apache-2.0 | silo.pgsty.com |  |
| pg_exporter | PostgreSQL & Pgbouncer metrics for Prometheus, declared in pure SQL | exp.pgsty.com |  |
| pig | The missing extension package manager for PostgreSQL | pig.pgsty.com |  |
| oink | Knowledge publishing framework — markdown in, modern docs out | oink.pgsty.com |  |
| sow | Software object warehouse — builds and mirrors APT & YUM repos | sow.pgsty.com |  |
| farrow | One inventory, one deploy — fixed-IP QEMU VMs on macOS and Linux | farrow.pgsty.com |  |
Silo family: mc (client) · silo-console (admin UI) · silo-go (SDK) · kes (key server) · minio-docs
PGEXT.CLOUD — 2200+ PostgreSQL extensions indexed, 570+ packaged for EL, Debian & Ubuntu.
| Repo | What it is | ★ |
|---|---|---|
| pgext | Metadata, docs and catalog behind PGEXT.CLOUD |  |
| extension | The extension catalog data pipeline |  |
| rpm | Extension RPM recipes, in addition to the PGDG YUM repo |  |
| deb | Extension DEB recipes, in addition to the PGDG APT repo |  |
| infra-pkg | RPM & DEB builds for Prometheus, Grafana and friends |  |
| image | Docker image for PostgreSQL with every extension baked in |  |
PG.CENTER — PostgreSQL documentation, searchable and cross-versioned. Four atlases sit on top of it:
| Atlas | What's in it |
|---|---|
| guc.pg.center | Every configuration parameter — 447 GUCs, PG 9.0 → 19 Beta, with history, defaults and tuning guidance |
| wait.pg.center | Every wait event, PG 13 → 18 — what the backend waits on, and what an operator should do next |
| err.pg.center | Every error code — all 263 SQLSTATEs, with failure stage, diagnosis and recovery |
| cat.pg.center | Every system catalog — 157 relations traced across 17 major versions |
| Repo | What it is | Site |
|---|---|---|
| pgweb | postgresql.org, rebuilt bilingual | pgsql.cc |
| pgdoc | Chinese translation of the PostgreSQL manual | pgsql.cc/docs |
| pgnls | Chinese zh_CN message catalogs, upstreamed to PostgreSQL |
pgsql.cc/nls |
| Repo | What it is |
|---|---|
| piglet.run | PG-centric AI infra sandbox for agents — docs |
| pgs3 | S3 interface as a PostgreSQL extension, in Rust |
| sim | Isometric 3D digital twin of a Pigsty HA cluster — live |
| go-patroni | Go SDK for the Patroni API |
| dbrank | DBMS trending data analysis |
Kernel forks & other repos
Pigsty ships 12 PostgreSQL kernel forks. The ones tracked here:
- openHalo — PostgreSQL that speaks the MySQL wire protocol
- oriolepg — PostgreSQL with OrioleDB extensibility and performance patches
Also in the org:
- pkg · docker · homebrew-infra — packages, images and taps
- oink-starter — minimal multilingual starter for the OINK theme
- acdat — Aho-Corasick automaton with double-array trie, in Go
Everything here is free and open source under Apache-2.0. Commercial support, consulting and subscriptions: pgsty.com.
