PostgreSQL in Great STYle

PostgreSQL in Great STYle

Battery-Included, Open-Source, Local-First PostgreSQL Distribution

Get StartedLive Demo
preview
1

Install Pigsty

One command to install PostgreSQL RDS with 420+ extensions.

grafana @ :3000

admin:pigsty
 Terminal
curl https://repo.pigsty.io/get | bash -s v3.5.0 $ cd ~/pigsty$ ./bootstrap$ ./configure$ ./install.yml
2

Deploy Clusters

Spin up multi-node, self-healing HA Database Clusters with code.

pg-prod:
  hosts:
    10.10.10.11: { pg_seq: 1, pg_role: primary }
    10.10.10.12: { pg_seq: 2, pg_role: replica }
    10.10.10.13: { pg_seq: 3, pg_role: offline }
  vars: { pg_cluster: pg-prod }
3

Deliver Service

Deliver enterprise-grade database service in minutes, without caring about details.



Architecture

The FOSS RDS Alternative

A Gift to the Community

DBA as a Software, written for ourselves. Self-hosting PG Like a Pro!

Pigsty turn the kernels and OSS tools into a integrated solution, makes it easy to self-hosting your own production-grade RDS. Launch without DBA expertise, save 90%+ cost than cloud RDS.

RDS Alternative

The PG Database Distribution

Unite the PG Ecosystem

PostgreSQL is eating the database world, Let's unite these extension superpowers!

Harness the superpower of PostgreSQL ecosystem! with unparalleled 420+ extensions. Simulate Oracle, MySQL, MSSQL, MONGO with exotic kernels, self-hosting Supabase, scaling with citus; analytic with duckdb; Explore the world of possibility and maximize the synergistic effect of the ecosystem. Just use PostgreSQL for Everything, and it's time to conquer the database world with postgres.

Ecosystem

Highlights

Extension Overwhelming

Gather the superpower of 420+ PG Extensions out-of-the-box together

High-Availability

Self-Healing architecture with reliable services access, 0-downtime migration

Observability Stack

Prometheus & Grafana best practice. Dashboards with unparalleled visibility

PG Kernel Replacement

Simulating Oracle, MySQL, SQL Server, and MongoDB with exotic kernel forks

Enterprise Security

Auto configured PITR, Backup Encryption, ACL Model, Local CA, SSL Certs, AuditLog

Infrastructure as Code

Describe and materialize entire infra & database clusters with code & playbook

Self-Hosting Supabase

Tun postgres into a full-featured BaaS, Migration in an hour, scale to billion

No Container / Raw Linux

Run directly on mainstream Linux distros. No need for containers & kubernetes

Application Templates

Launch enterprise software like Odoo, Dify, Gitlab, Jira, Wiki.js, Gitea at ease

Blossom of Possibilities

Nurturing all, thriving in synergy, forging infinite possibilities!

Analytics

OLAP's new challenger

AI Ready

RAG / Vector Defaults

Geospatial

De facto GIS standard

Time Series

Temporal data mastery

Featured

Database as a Platform

Full-Text Search

Built-in search engine

PL Languages

Procedure Language

FDW Federation

Connecting data silos

Self-Hosting like a Pro

Everything you need for a production-grade PostgreSQL service

  • Battery IncludedAll you need for enterprise PostgreSQL, out of the box
  • Open Source100% open-source, FOSS license, community-driven
  • Local-FirstRun anywhere, own your data, no more vendor lock-in
  • Get StartedShow cases