# pgsty/pigsty

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!

Repository: https://github.com/pgsty/pigsty
Canonical: https://ross.abutalabs.com/products/pigsty
Homepage: https://pigsty.io
Language: Shell
License: Apache-2.0
License Family: permissive
Topics: postgres, graphics, infra, service, toolbox, yours
Last push: 2026-08-24T06:23:03+00:00

## Health v2 (maintenance only)
Score: 95/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 99, release rhythm 86, longevity 100
- inputs: {"age_days": 2284, "days_push": 9, "days_rel": 19, "gap_med": 31, "n_releases_24m": 22}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 5575, forks 379 (observed 2026-08-28T04:09:22.506951+00:00)

## What it is
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
- artifact type: infra-config
- maturity: stable
- function: database, monitoring, backup, infrastructure-as-code, caching, deployment, configuration-management, package-manager, security, analytics
- domain: databases, self-hosted, infrastructure-as-code, monitoring, cloud-computing, developer-tools
- platform: self-hosted, cli, cloud
- tags: 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

## Member repositories
- pgsty/pigsty (main) score 95

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:09:22.506951+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T17:55:34.614038+00:00, confidence not recorded.
  - readme: https://github.com/pgsty/pigsty (fetched 2026-08-28T04:09:22.506951+00:00, sha 4c81a8397b65)
  - homepage: https://pigsty.io (fetched 2026-08-29T08:50:42.591666+00:00, sha 92dd7d5976c8)
  - site_page: https://pigsty.io/docs (fetched 2026-08-29T08:50:42.594494+00:00, sha 644c834f9011)
  - site_page: https://pigsty.io/docs/about/release (fetched 2026-08-29T08:50:42.596586+00:00, sha dc62ff4a8fa2)
  - site_page: https://pigsty.io/docs/piglet (fetched 2026-08-29T08:50:42.601763+00:00, sha e59ad90389be)
  - site_page: https://pigsty.io/docs/pgsql/kernel (fetched 2026-08-29T08:50:42.603623+00:00, sha 493e6fb3d30f)
  - site_page: https://pigsty.io/docs/pig (fetched 2026-08-29T08:50:42.605359+00:00, sha c0f375bc28b1)
  - site_page: https://pigsty.io/docs/pgbouncer (fetched 2026-08-29T08:50:42.607115+00:00, sha 33edc6e087bf)
  - site_page: https://pigsty.io/docs/patroni (fetched 2026-08-29T08:50:42.608806+00:00, sha f8ba8e274954)
  - site_page: https://pigsty.io/docs/pgbackrest (fetched 2026-08-29T08:50:42.610511+00:00, sha bcf951bbbb26)
- Data as of 2026-08-30T08:39:29.467469+00:00.