Skip to content

Configuration Templates

Batteries-included configuration templates for specific scenarios, with detailed explanations.

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.

Default single-node installation template with extensive configuration parameter descriptions

Feature-rich single-node configuration with local software repository, all extensions, Silo backup, and complete examples

Minimal installation template without monitoring infrastructure, installs PostgreSQL directly from internet

Feature-All-Test template, single-node installation of all extensions, builds local repo with PG 14-18 all versions

Only installs observability infrastructure, dedicated template without PostgreSQL and etcd

VIBE AI coding sandbox config template, integrating Code-Server, JupyterLab, Claude Code, Codex CLI, and JuiceFS

Pigsty Docker single-node template for quickly bootstrapping Pigsty in containers.

Native PostgreSQL kernel with stable support for PostgreSQL 14 to 18 and a PG19 Beta evaluation option

Single-node PostgreSQL 19 Beta evaluation template with the PGDG Beta repository and default backup capabilities

Babelfish template pinned to a PostgreSQL 17-compatible kernel with SQL Server protocol and T-SQL support

PolarDB for PostgreSQL kernel, provides Aurora-style storage-compute separation capability

IvorySQL kernel, provides Oracle syntax and PL/SQL compatibility

AgensGraph kernel template with property graph model and Cypher query support

pgEdge kernel template for distributed multi-master PostgreSQL in edge scenarios

OpenHalo kernel, provides MySQL protocol and syntax compatibility

Percona PostgreSQL kernel, provides Transparent Data Encryption (pg_tde) capability

OrioleDB kernel, provides bloat-free OLTP enhanced storage engine

Run PostgreSQL in Mongo-compatible mode with DocumentDB and the FerretDB Docker APP.

20-node production environment simulation for large-scale deployment testing

Compact eight-node HA simulation with three INFRA nodes, five etcd nodes, eight object-storage nodes, and two PostgreSQL clusters.

Four-node complete feature demonstration environment with two PostgreSQL clusters, Silo, Redis, etc.

Three-node high-availability and security-hardening configuration example.

Three-node standard HA configuration where PostgreSQL, ETCD, and Silo tolerate one node failure

Two-node configuration, limited HA deployment tolerating specific server failure

13-node Citus distributed PostgreSQL cluster, 1 coordinator + 5 worker groups with HA

Minimal readable configuration declaring only INFRA, ETCD, and single-node PostgreSQL

Configuration template optimized for Enterprise Linux (RHEL/Rocky/Alma)

Configuration template optimized for Debian/Ubuntu

Pigsty public demo site configuration, showcasing SSL certificates, domain exposure, and full extension installation

Ten-node PostgreSQL kernel matrix demo configuration

Four-node x four-drive HA S3 object-storage cluster demo; current source defaults to Silo.

Four-node demo of Redis replica, Sentinel, and native Cluster modes

Four-node dynamic KRaft example with a plaintext single-node dev cluster and a three-node TLS/SCRAM HA baseline

Native MySQL 8.4 pilot template with a standalone instance and a three-node InnoDB Cluster

Pigsty open-source edition offline package build environment configuration

Pigsty three-node local build and development configuration

Monitor remote PostgreSQL and cloud RDS with pg_exporter instances on an INFRA node

Legacy single-node SaaS bundle with PostgreSQL, Silo, Redis, and multiple application entrypoints

Single-node tiny-tuning example for small cloud instances in China