Pigsty Docs v4.0

“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

GtiHub | Demo | Blog | Discuss | Discord | DeepWiki | Roadmap | 中文文档
Get Started with the latest release: curl -fsSL https://repo.pigsty.io/get | bash

About

Learn about Pigsty itself in every aspect - features, history, license, privacy policy, community events, and news.

Concepts

Understand Pigsty’s core concepts, architecture design, and principles. Master high availability, backup recovery, security compliance, and other key capabilities.

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, including supported OS distros, available modules, monitor metrics, extensions, cost comparison and analysis, glossary

Applications

Software and tools that use PostgreSQL can be managed by the docker daemon

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

Pigsty has built-in Redis support, a high-performance in-memory data structure server. Deploy Redis in standalone, cluster, or sentinel mode as a companion to PostgreSQL.