Configuration

Batteries-included config templates for specific scenarios, and detailed explanations.

Overview

Batteries-included config templates for specific scenarios, and detailed explanations.

1-node: meta

Default single-node installation template with extensive configuration parameter descriptions.

1-node: rich

Downloads all available PostgreSQL extensions and Docker, provisioning a series of databases for software backups.

1-node: demo

Configuration file used by the Pigsty demo site, configured to serve publicly with domain names and certificates.

1-node: pitr

A single-node configuration sample for continuous backups and PITR using remote S3/object storage.

1-node: supa

Run self-hosting supabase on existing PostgreSQL

1-node: bare

The minimal single-node config template, with only the essential components required to run a PostgreSQL instance.

4-node: full

A four-node standard sandbox demonstration environment, featuring two PostgreSQL clusters, MinIO, Etcd, Redis, and a sample FerretDB cluster.

4-node: safe

A 3+1 node template with hardened security, delayed cluster, following high-standard security best practices.

4-node: mssql

Replaces PostgreSQL with a Microsoft SQL Server-compatible kernel using WiltonDB or Babelfish.

4-node: polar

Substitutes native PostgreSQL with Alibaba Cloud’s PolarDB for PostgreSQL kernel.

4-node: ivory

Replaces native PostgreSQL with IvorySQL, an Oracle-compatible kernel by HighGo.

4-node: minio

4-node HA MinIO MNMD cluster to provide S3-compatible object storage services.

2-node: dual

Dual-node template to set up a basic high-availability PostgreSQL cluster with master-slave replication, tolerating the failure of one node.

2-node: slim

Minimal installation that avoids setting up local software repositories or infrastructure, relying only on etcd for a highly available PostgreSQL cluster.

3-node: trio

Three-node configuration template providing a standard High Availability (HA) architecture, tolerating failure of one out of three nodes.

5-node: oss

Building offline packages for 5 major OS distro simultaneously.

5-node: ext

5-node extension building template for 5 major OS distro

36-node: prod

Production environment simulation with 43 nodes