Pigsty v5.0 Pigsty v4.5 Pigsty v3.7 Pigsty v2.7 Pigsty v1.5

English
简体中文

Docs From core concepts and quick start to production deployment, module references, and day-to-day operations. Blog Pigsty articles, engineering design notes, and the complete release archive.

Docs
- PIGSTY
- Get Started
  Quick Start
  
  Docker
  
  Web UI
  
  Use PG
  
  Customize
  
  Playbook
  
  Offline
  
  Slim
  
  Security Recommendations
- Deployment
  Prod Install
  
  Preparation
  
  Arch Planning
  
  Admin Setup
  
  Sandbox
  
  Vagrant
  
  OpenTofu
  
  Security Considerations
- Concepts
  Architecture
  
  Nodes
  
  Infrastructure
  
  PGSQL Arch
  
  ER Model
  
  Infra Cluster
  
  PGSQL Cluster
  
  Etcd Cluster
  
  Object Storage Cluster
  
  Redis Cluster
  
  Infra as Code
  
  Inventory
  
  Configure
  
  Parameters
  
  Templates
  
  CMDB
  
  High Availability
  
  RPO Trade-offs
  
  Failure Model
  
  Expire Failure
  
  Crash Failure
  
  Network Partition
  
  RTO Trade-offs
  
  Service Access
  
  PITR
  
  Mechanism
  
  Architecture
  
  Tradeoffs
  
  Recovery
  
  Scenarios
  
  Security
  
  Security Model
  
  Authentication
  
  Access Control
  
  Encrypted Communication
  
  Data Security
  
  Compliance
- References
  Supported Linux
  
  Modules
  
  File Hierarchy
  
  Parameters
  
  Playbooks
  
  Port List
- About
  Features
  
  History
  
  Events
  
  Roadmap
  
  Community
  
  Privacy Policy
  
  License
  
  Sponsor Us
  
  User Cases
  
  Subscription
  
  FAQ
  
  Comparison
  
  Cost Reference
  
  Open-Source Impact
- Examples
  Solo Templates
  
  meta
  
  rich
  
  slim
  
  fat
  
  infra
  
  vibe
  
  docker
  
  Kernel Templates
  
  pgsql
  
  pg19
  
  mssql
  
  polar
  
  ivory
  
  agens
  
  pgedge
  
  mysql
  
  pgtde
  
  oriole
  
  Mongo
  
  HA Templates
  
  ha/simu
  
  ha/octo
  
  ha/full
  
  ha/safe
  
  ha/trio
  
  ha/dual
  
  ha/citus
  
  Misc Templates
  
  demo/bare
  
  demo/el
  
  demo/debian
  
  demo/demo
  
  demo/kernel
  
  demo/minio
  
  demo/redis
  
  demo/kafka
  
  demo/mysql
  
  build/oss
  
  build/dev
  
  demo/remote
  
  demo/saas
  
  demo/wool
- Modules
- Module: PGSQL
  Core Concepts
  
  Configuration
  
  Cluster / Instance
  
  Kernel Version
  
  Package Alias
  
  User/Role
  
  Database
  
  HBA Rules
  
  Access Control
  
  Parameters
  
  Service/Access
  
  Security
  
  Administration
  
  Administration
  
  Cluster Admin
  
  User Admin
  
  Database Admin
  
  Patroni HA Admin
  
  HBA Admin
  
  Pgbouncer Admin
  
  Component Admin
  
  Crontab Admin
  
  Extension Admin
  
  Version Upgrade
  
  Backup & Restore
  
  Backup Policy
  
  Restore Operations
  
  Clone a PG Cluster
  
  Backup Mechanism
  
  Backup Repository
  
  Admin Commands
  
  Data Migration
  
  Tutorials
  
  Troubleshooting
  
  Manual PITR Drill
  
  Enable HugePage
  
  Fork Instance
  
  Accidental Deletion
  
  HA Drill: 2/3 Failure
  
  Bind a L2 PG VIP
  
  Setup HA Citus
  
  Reference
  
  Monitoring
  
  Dashboard
  
  Overview
  
  PGSQL Overview
  
  PGSQL Alert
  
  PGSQL Shard
  
  Cluster
  
  PGSQL Cluster
  
  PGRDS Cluster
  
  PGSQL Activity
  
  PGSQL Replication
  
  PGSQL Service
  
  PGSQL Databases
  
  PGSQL Patroni
  
  PGSQL PITR
  
  Instance
  
  PGSQL Instance
  
  PGRDS Instance
  
  PGCAT Instance
  
  PGSQL Persist
  
  PGSQL Proxy
  
  PGSQL Pgbouncer
  
  PGSQL Session
  
  PGSQL Xacts
  
  PGSQL Exporter
  
  Database
  
  PGSQL Database
  
  PGCAT Database
  
  PGSQL Tables
  
  PGSQL Table
  
  PGCAT Table
  
  PGSQL Query
  
  PGCAT Query
  
  PGCAT Locks
  
  PGCAT Schema
  
  Metrics
  
  Parameters
  
  Playbook
  
  Extensions
  
  Quick Start
  
  Introduction
  
  Packages
  
  Download
  
  Install
  
  Config
  
  Create
  
  Update
  
  Remove
  
  Default Extensions
  
  Repository
  
  PG Kernels
  
  PostgreSQL
  
  Supabase
  
  Babelfish
  
  Percona
  
  openHalo
  
  OrioleDB
  
  Cloudberry
  
  AgensGraph
  
  pgEdge
  
  DocumentDB
  
  Citus
  
  IvorySQL
  
  PolarDB PG
  
  PolarDB Oracle
  
  Param Templates
  
  Optimize Params
  
  OLTP Template
  
  OLAP Template
  
  CRIT Template
  
  TINY Template
  
  FAQ
- Module: INFRA
  Configuration
  
  Parameters
  
  Playbook
  
  Monitoring
  
  Metrics
  
  FAQ
  
  Administration
  
  Nginx Management
  
  Software Repository
  
  Domain Management
  
  Module Management
  
  CA and Certificates
  
  Grafana HA
- Module: NODE
  Configuration
  
  Parameters
  
  Playbook
  
  Administration
  
  Monitoring
  
  Metrics
  
  FAQ
- Module: ETCD
  Configuration
  
  Parameters
  
  Administration
  
  Playbook
  
  Monitoring
  
  Metrics
  
  FAQ
- Module: MINIO
  Usage
  
  Configuration
  
  Parameters
  
  Playbook
  
  Administration
  
  Monitoring and Alerting
  
  Metrics
  
  FAQ
- Module: REDIS
  Configuration
  
  Parameters
  
  Playbook
  
  Administration
  
  Monitoring
  
  Metrics
  
  FAQ
- Module: DOCKER
  Usage
  
  Parameters
  
  Playbooks
  
  Metrics
  
  FAQ
- Module: JUICE
  Configuration
  
  Parameters
  
  Playbook
  
  Administration
  
  Monitoring
  
  FAQ
- Module: VIBE
  Configuration
  
  Parameters
  
  Playbook
  
  Administration
  
  Monitoring
  
  FAQ
- Module: KAFKA
  Quick Start
  
  Configuration
  
  Parameters
  
  Administration
  
  Playbook
  
  Monitoring
  
  Metrics
  
  FAQ
- Module: MYSQL
  Configuration
  
  Parameters
  
  Administration
  
  Playbook
  
  Monitoring
  
  Metrics
  
  FAQ

Docs
Examples
Misc Templates

Open in ChatGPT
Open in Claude
View markdown
Print entire section

Misc Templates

PGSQL103 PIGSTY58 KAFKA9 MINIO9 MYSQL8 REDIS8 ETCD7 INFRA7 JUICE7 VIBE7 DOCKER5 SOFTWARE1

Powered by OINK 1.0.0

Pigsty v5.0
Pigsty v4.5
Pigsty v3.7
Pigsty v2.7
Pigsty v1.5

简体中文

English
简体中文

Keyboard shortcuts

Section navigation

WS↑↓: Move through sidebar
AD←→: Collapse or expand section
EnterG: Open focused page
JK: Previous or next heading
QE: Previous or next page

Actions

/F: Search
\C: Command palette
H: Reading mode
LY: Switch language
T: Switch theme
R: Cycle top-level pages

↑↓ Navigate ↵ Open esc Close