Configuration

Batteries-included config templates for specific scenarios, and detailed explanations.
Module:
Categories:
1-node 2-node 3-node 4-node 5+node
meta dual trio full prod
rich slim safe mssql oss
pitr pg16 infra polar pro
demo supa minio ivory citus
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: supa

Run self-hosting single node supabase

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.

4-node: full

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

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.

5-node: oss

Building offline packages for 5 major OS distro simultaneously.

43-node: prod

Production environment simulation with 43 nodes


Last modified 2024-11-12: move pgext to another place (b1ae2068)