meta
Default single-node installation template with extensive configuration parameter descriptions
Configuration Templates
Batteries-included configuration templates for specific scenarios, with detailed explanations.
The current main branch (v4.5.0 development) provides 50 distinct YAML templates under conf/ for deployment, testing, and package-build scenarios. The latest stable release, v4.4.0, provides 48. The app/supa.yml compatibility symlink to supabase.yml is not counted twice.
Use -c with configure to select a template. Its value is a path relative to conf/ without the .yml suffix. If omitted, Pigsty uses the default meta template.
| Category | Templates |
|---|---|
| Solo Templates | meta, rich, fat, slim, infra, vibe, docker |
| Kernel Templates | pgsql, pg19, mssql, polar, ivory, agens, pgedge, mysql (OpenHalo), mongo, pgtde, oriole |
| HA Templates | ha/simu, ha/citus, ha/full, ha/safe, ha/trio, ha/dual |
| App Templates | supabase, app/odoo, app/dify, app/insforge, app/hindsight, app/electric, app/maybe, app/teable, app/mattermost, app/registry, app/immich, app/jumpserver |
| Misc Templates | demo/bare, demo/el, demo/debian, demo/demo, demo/kernel, demo/redis, demo/minio, demo/kafka, demo/mysql (native MySQL pilot), demo/remote, demo/saas, demo/wool, build/oss, build/dev |
rich
Feature-rich single-node configuration with local software repository, all extensions, MinIO backup, and complete examples
slim
Minimal installation template without monitoring infrastructure, installs PostgreSQL directly from internet
fat
Feature-All-Test template, single-node installation of all extensions, builds local repo with PG 14-18 all versions
infra
Only installs observability infrastructure, dedicated template without PostgreSQL and etcd
vibe
VIBE AI coding sandbox config template, integrating Code-Server, JupyterLab, Claude Code, Codex CLI, and JuiceFS
docker
Pigsty Docker single-node template for quickly bootstrapping Pigsty in containers.
pgsql
Native PostgreSQL kernel with stable support for PostgreSQL 14 to 18 and a PG19 Beta evaluation option
pg19
Single-node PostgreSQL 19 Beta evaluation template with the PGDG Beta repository and default backup capabilities
mssql
Babelfish template pinned to a PostgreSQL 17-compatible kernel with SQL Server protocol and T-SQL support
polar
PolarDB for PostgreSQL kernel, provides Aurora-style storage-compute separation capability
ivory
IvorySQL kernel, provides Oracle syntax and PL/SQL compatibility
agens
AgensGraph kernel template with property graph model and Cypher query support
pgedge
pgEdge kernel template for distributed multi-master PostgreSQL in edge scenarios
mysql
OpenHalo kernel, provides MySQL protocol and syntax compatibility
pgtde
Percona PostgreSQL kernel, provides Transparent Data Encryption (pg_tde) capability
oriole
OrioleDB kernel, provides bloat-free OLTP enhanced storage engine
mongo
DocumentDB + FerretDB template providing Mongo wire compatibility on PostgreSQL.
ha/simu
20-node production environment simulation for large-scale deployment testing
ha/full
Four-node complete feature demonstration environment with two PostgreSQL clusters, MinIO, Redis, etc.
ha/safe
Three-node high-availability and security-hardening configuration example.
ha/trio
Three-node standard HA configuration, tolerates any single server failure
ha/dual
Two-node configuration, limited HA deployment tolerating specific server failure
ha/citus
13-node Citus distributed PostgreSQL cluster, 1 coordinator + 5 worker groups with HA
supabase
Self-host Supabase using Pigsty-managed PostgreSQL, an open-source Firebase alternative
app/odoo
Deploy Odoo open-source ERP system using Pigsty-managed PostgreSQL
app/dify
Deploy Dify AI application development platform using Pigsty-managed PostgreSQL
app/electric
Deploy Electric real-time sync service using Pigsty-managed PostgreSQL
app/maybe
Deploy Maybe personal finance management system using Pigsty-managed PostgreSQL
app/teable
Deploy Teable open-source Airtable alternative using Pigsty-managed PostgreSQL
app/mattermost
Mattermost template for one-click team collaboration deployment with Pigsty PostgreSQL and Docker.
app/registry
Deploy Docker Registry image proxy and private registry using Pigsty
app/insforge
Deploy the InsForge Backend-as-a-Service platform with Pigsty-managed PostgreSQL
app/hindsight
Deploy the Hindsight AI long-term memory service with Pigsty-managed PostgreSQL
app/immich
Deploy Immich photo and video management with Pigsty-managed PostgreSQL and VectorChord
app/jumpserver
Deploy the JumpServer open-source bastion host with Pigsty-managed PostgreSQL
demo/bare
Minimal readable configuration declaring only INFRA, ETCD, and single-node PostgreSQL
demo/el
Configuration template optimized for Enterprise Linux (RHEL/Rocky/Alma)
demo/debian
Configuration template optimized for Debian/Ubuntu
demo/demo
Pigsty public demo site configuration, showcasing SSL certificates, domain exposure, and full extension installation
demo/kernel
Ten-node PostgreSQL kernel matrix demo configuration
demo/minio
Four-node x four-drive high-availability multi-node multi-disk MinIO cluster demo
demo/redis
Four-node demo of Redis replica, Sentinel, and native Cluster modes
demo/kafka
Four-node dynamic KRaft example with a plaintext single-node dev cluster and a three-node TLS/SCRAM HA baseline
demo/mysql
Native MySQL 8.4 pilot template with a standalone instance and a three-node InnoDB Cluster
build/oss
Pigsty open-source edition offline package build environment configuration
build/dev
Pigsty three-node local build and development configuration
demo/remote
Monitor remote PostgreSQL and cloud RDS with pg_exporter instances on an INFRA node
demo/saas
Legacy single-node SaaS bundle with PostgreSQL, MinIO, Redis, and multiple application entrypoints
demo/wool
Single-node tiny-tuning example for small cloud instances in China
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.