About
Learn about Pigsty itself in every aspect - features, history, license, privacy policy, community, and news.
Pigsty Docs v4.2
“PostgreSQL In Great STYle”: Postgres, Infras, Graphics, Service, Toolbox, it’s all Yours.
—— Battery-Included, Local-First PostgreSQL Distribution as an Free & Open-Source RDS
GitHub | Demo | Blog | Discuss | Discord | DeepWiki | Roadmap | Chinese Docs
Get Started with the latest release:
curl -fsSL https://repo.pigsty.io/get | bash -s v4.2.1
About: Features | History | Event | Community | Privacy Policy | License | Sponsor | Subscription
Setup: Install | Offline Install | Preparation | Configuration | Playbook | Provision | Security | FAQ
Concept: Architecture | Cluster Model | Monitoring | IaC | HA | PITR | Service Access | Security
Reference: Supported Linux | Fire Hierarchy | Parameters | Playbooks | Ports | Comparison | Cost
Modules: PGSQL | INFRA | NODE | ETCD | MINIO | REDIS | FERRET | DOCKER | APP | JUICE | VIBE
Concepts
Understand Pigsty’s core concepts, architecture design, learn how high availability, backup recovery, iac, security works
Get Started
Deploy Pigsty single-node version on your laptop/cloud server, access DB and Web UI
Deployment
Multi-node, high-availability Pigsty deployment for serious production environments.
References
Detailed reference information and lists, supported Linux distros, available modules, metrics, extensions, and more.
Applications
Application templates and data applets: run stateless apps with Docker Compose and host state in external PostgreSQL and MinIO.
Conf Templates
Batteries-included configuration templates for specific scenarios, with detailed explanations.
Module: PGSQL
Deploy and manage world’s most advanced open-source relational database — PostgreSQL, customizable and production-ready!
Module: INFRA
Optional standalone infrastructure that provides NTP, DNS, observability and other foundational services for PostgreSQL.
Module: NODE
Tune nodes into the desired state and monitor it, manage node, VIP, HAProxy, and exporters.
Module: ETCD
Pigsty deploys etcd as DCS for reliable distributed config storage, supporting PostgreSQL HA.
Module: MINIO
Pigsty has built-in MinIO support, an open-source S3-compatible object storage that can be used for PGSQL cold backup storage.
Module: REDIS
Built-in Redis support in standalone, cluster, or sentinel mode as a companion to PostgreSQL.
Module: FERRET
Add MongoDB-compatible protocol support to PostgreSQL using FerretDB
Module: DOCKER
Docker daemon service that enables one-click deployment of containerized stateless software templates and additional functionality.
Module: JUICE
Use JuiceFS distributed filesystem with PostgreSQL metadata to provide shared POSIX storage.
Module: VIBE
Deploy an AI coding sandbox with Pigsty: Code-Server, JupyterLab, Node.js, and Claude Code.
Module: PILOT
Extra modules in pilot development.
PIG - PG CLI and Extension Package Manager
PostgreSQL Extension Ecosystem Package Manager
Linux Repository
The APT / DNF repository to deliver PostgreSQL Kernel, Extensions and Infra packages.
Piglet Runtime: AI Runtime Sandbox
Pigsty Lightweight Runtime, AI Coding sandbox, spin up your cloud coding environment with one click
Patroni 4.1 Documentation
Overview of Patroni high-availability documentation for PostgreSQL.
pgBouncer 1.25 Documentation
PgBouncer - Lightweight connection pooler for PostgreSQL
pgBackRest 2.58 Documentation
Reliable PostgreSQL Backup & Restore — pgBackRest documentation and reference.
PG Exporter 1.2 Documentation
Advanced PostgreSQL & pgBouncer Metrics Exporter for Prometheus
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.