meta
Default single-node installation template with extensive configuration parameter descriptions
Configuration Templates
Batteries-included configuration templates for specific scenarios, with detailed explanations.
Pigsty provides various ready-to-use configuration templates for different deployment scenarios.
You can specify a configuration template with the -c option during configure. If no template is specified, the default meta template is used.
| Category | Templates |
|---|---|
| Solo Templates | meta, rich, fat, slim, infra, vibe, docker |
| Kernel Templates | pgsql, mssql, polar, ivory, agens, pgedge, mysql, mongo, pgtde, oriole, supabase |
| HA Templates | ha/simu, ha/citus, ha/full, ha/safe, ha/trio, ha/dual |
| App Templates | app/odoo, app/dify, app/insforge, app/hindsight, app/electric, app/maybe, app/teable, app/mattermost, app/registry |
| Misc Templates | demo/el, demo/debian, demo/demo, demo/kernel, demo/minio, 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 and JuiceFS web development environment
docker
Pigsty Docker single-node template for quickly bootstrapping Pigsty in containers.
pgsql
Native PostgreSQL kernel, supports deployment of PostgreSQL versions 14 to 18
mssql
Babelfish (PG17) kernel template, providing Microsoft SQL Server protocol and T-SQL compatibility
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.
supabase
Self-host Supabase using Pigsty-managed PostgreSQL, an open-source Firebase alternative
ha/citus
13-node Citus distributed PostgreSQL cluster, 1 coordinator + 5 worker groups with HA
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
Security-hardened HA configuration template with high-standard security best practices
ha/trio
Three-node standard HA configuration, tolerates any single server failure
ha/dual
Two-node configuration, limited HA deployment tolerating specific server failure
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
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
build/oss
Pigsty open-source edition offline package build environment configuration
build/dev
Pigsty three-node local build and development configuration
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.