pgsty/pigsty resource
Enterprise-Grade OSS PostgreSQL Distribution with HA, PITR, IaC, Monitor, 12 kernel forks and 575 PG extensions. Best-of-breed products integrated as a platform. Self-host Postgres like a Pro! observed · 2026-08-28
Health v2 · maintenance only
95/100
- Activity 99
- Release rhythm 86
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: 31
- age_days: 2284
- days_rel: 19
- days_push: 9
- n_releases_24m: 22
Adoption not part of the score
5575 stars · 379 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded
Pigsty is an enterprise-grade, open-source PostgreSQL distribution that bundles HA (Patroni/etcd), backup/PITR (pgBackRest), connection pooling, observability (Grafana/VictoriaMetrics), and 575+ packaged PG extensions into an Ansible-based IaC platform. It scales from a laptop sandbox to multi-node datacenter clusters and includes a 'pig' extension package manager and an AI coding sandbox runtime (Piglet).
Use cases
- self-host a managed-Postgres-like RDS alternative
- set up a high-availability PostgreSQL cluster with automatic failover
- get point-in-time recovery and backups for Postgres
- install and manage hundreds of PostgreSQL extensions easily
- monitor PostgreSQL with Grafana dashboards out of the box
- provision Postgres clusters with infrastructure-as-code
- run a local Postgres dev environment with vector and timeseries extensions
- spin up an AI coding sandbox with Postgres included
When to choose
- you want production-grade self-hosted PostgreSQL with HA, PITR, and monitoring in one battery-included package
- you need many PG extensions (vector, geo, timeseries, graph) available out of the box
- you prefer Linux-native Ansible-based deployment without Kubernetes or Docker
- you want a free open-source alternative to cloud RDS with full control
When to avoid
- you only need a simple single Postgres instance without HA or observability overhead
- your environment is not Linux or you require a fully managed cloud database service
- you are locked into Kubernetes-operator-based Postgres workflows
- you need non-PostgreSQL databases as the primary platform
Facets
infra-config · maturity stable
database monitoring backup infrastructure-as-code caching deployment configuration-management package-manager security analytics databases self-hosted infrastructure-as-code monitoring cloud-computing developer-tools self-hosted cli cloud postgresql high-availability pitr patroni pgbouncer pgbackrest grafana prometheus victoriametrics minio etcd ansible postgres-extensions rds-alternative supabase citus greenplum ai-coding-sandbox devops linux docker
10 sources
- readme: https://github.com/pgsty/pigsty · fetched 2026-08-28 · 4c81a8397b65
- homepage: https://pigsty.io · fetched 2026-08-29 · 92dd7d5976c8
- site_page: https://pigsty.io/docs · fetched 2026-08-29 · 644c834f9011
- site_page: https://pigsty.io/docs/about/release · fetched 2026-08-29 · dc62ff4a8fa2
- site_page: https://pigsty.io/docs/piglet · fetched 2026-08-29 · e59ad90389be
- site_page: https://pigsty.io/docs/pgsql/kernel · fetched 2026-08-29 · 493e6fb3d30f
- site_page: https://pigsty.io/docs/pig · fetched 2026-08-29 · c0f375bc28b1
- site_page: https://pigsty.io/docs/pgbouncer · fetched 2026-08-29 · 33edc6e087bf
- site_page: https://pigsty.io/docs/patroni · fetched 2026-08-29 · f8ba8e274954
- site_page: https://pigsty.io/docs/pgbackrest · fetched 2026-08-29 · bcf951bbbb26
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| pgsty/pigsty | main | 95 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem