meta
Default single-node installation template with extensive configuration parameter descriptions
Conf 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 |
| Kernel Templates | pgsql, citus, mssql, polar, ivory, mysql, pgtde, oriole, supabase |
| HA Templates | ha/simu, ha/full, ha/safe, ha/trio, ha/dual |
| App Templates | app/odoo, app/dify, app/electric, app/maybe, app/teable, app/registry |
| Misc Templates | demo/el, demo/debian, demo/demo, demo/minio, build/oss, build/pro |
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 13-18 all versions
infra
Only installs observability infrastructure, dedicated template without PostgreSQL and etcd
pgsql
Native PostgreSQL kernel, supports deployment of PostgreSQL versions 13 to 18
citus
Citus distributed PostgreSQL cluster, provides horizontal scaling and sharding capabilities
mssql
WiltonDB / Babelfish kernel, provides Microsoft SQL Server protocol and syntax compatibility
polar
PolarDB for PostgreSQL kernel, provides Aurora-style storage-compute separation capability
ivory
IvorySQL kernel, provides Oracle syntax and PL/SQL compatibility
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
supabase
Self-host Supabase using Pigsty-managed PostgreSQL, an open-source Firebase alternative
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/registry
Deploy Docker Registry image proxy and private registry using Pigsty
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/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/pro
Pigsty professional edition offline package build environment configuration (multi-version)
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.