# Template

> Configuration templates for Pigsty
---

This directory [`conf`](https://github.com/pgsty/pigsty/tree/v3.7.0/conf) contains pigsty config templates, which will be used during [`configure`](/docs/config/configure) procedure.

Config templates can be designated using `./configure -c <conf>`, where the conf is a relative path to `conf` directory (with or without `.yml` suffix).
e.g. the `~/pigsty/conf/rich.yml` can be specified as `rich`

```bash
./configure                     # use the meta.yml config template by default
./configure -c meta             # use the meta.yml 1-node template explicitly
./configure -c rich             # use the 1-node template with all extensions & minio
./configure -c slim             # use the minimal 1-node template
./configure -c supabase         # use the Supabase 1-node template
./configure -c app/dify         # use the dify app template
```

If no `-c|--conf` is given, the single-node `meta` config template will be automatically selected by default.




----------

## Basic Templates

Here are one-node templates, which provide different features and configurations.

| Template                                                              | Node | Description                                                   |
|:----------------------------------------------------------------------|:----:|---------------------------------------------------------------|
| [`meta.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/meta.yml) |  1   | Default 1-node config, pgsql, infra, node, etcd, minimal ext  |
| [`rich.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/rich.yml) |  1   | meta + minio + all  extensions                                |
| [`slim.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/slim.yml) |  1   | meta - infra - node monitor, minimal install                  |
| [`fat.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/fat.yml)   |  1   | PG 13-18 packages, and install all extensions for current ver |


--------

## Exotic Kernel

Using exotic Postgres kernel forks:

| Template                                                                  | Node | Description                                          |
|---------------------------------------------------------------------------|:----:|------------------------------------------------------|
| [`mssql.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/mssql.yml)   |  1   | WiltonDB & Babelfish with MSSQL wire-compatibility   |
| [`polar.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/polar.yml)   |  1   | PolarDB for PostgreSQL with Aurora RAC Flavor        |
| [`ivory.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/ivory.yml)   |  1   | IvorySQL cluster with Oracle compatibility           |
| [`mysql.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/mysql.yml)   |  1   | Halo cluster with MySQL wire-compatibility           |
| [`mongo.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/mongo.yml)   |  1   | FerretDB & DocumentDB with Mongo wire-compatibility  |
| [`oriole.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/oriole.yml) |  1   | OrioleDB cluster with OLTP enhancement               |


--------

## Multi Node

| Template                                                              | Node | Description                               |
|-----------------------------------------------------------------------|:----:|-------------------------------------------|
| [`dual.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/ha/dual.yml) |  2   | Semi-HA deployment                        |
| [`trio.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/ha/trio.yml) |  3   | Standard HA deployment                    |
| [`full.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/ha/full.yml) |  4   | Sandbox deployment                        |
| [`safe.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/ha/safe.yml) |  4   | Security enhancement with delayed replica |
| [`simu.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/ha/simu.yml) |  36  | Production simulation                     |


--------

## Applications

| Template                                                                              | Description                         |
|---------------------------------------------------------------------------------------|-------------------------------------|
| [`app/supa.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/app/supa.yml)         | Launch 1-node supabase              |
| [`app/odoo.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/app/odoo.yml)         | Launch the odoo ERP system          |
| [`app/dify.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/app/dify.yml)         | Launch the dify AI workflow system  |
| [`app/electric.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/app/electric.yml) | Launch the electric sync engine app |

--------

## Demo Templates

| Template                                                                            | Description                                                       |
|-------------------------------------------------------------------------------------|-------------------------------------------------------------------|
| [`demo/el.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/demo/el.yml)         | Config file with all default parameters for EL 8/9/10 systems        |
| [`demo/debian.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/demo/debian.yml) | Config file with all default parameters for debian/ubuntu systems |
| [`demo/remote.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/demo/remote.yml) | Example config for monitoring a remote pgsql cluster or RDS PG    |
| [`demo/redis.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/demo/redis.yml)   | Example config for redis clusters                                 |
| [`demo/minio.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/demo/minio.yml)   | Example config for a 3-node minio clusters                        |
| [`demo/demo.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/demo/demo.yml)     | Config file for the pigsty [public demo](https://g.pgsty.com)     |
| [`citus.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/citus.yml)   | Citus cluster example: 1 coordinator and 3 data nodes (4-node)    |


--------

## Build Templates

| Template                                                                        | Description                                                        |
|---------------------------------------------------------------------------------|--------------------------------------------------------------------|
| [`build/oss.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/build/oss.yml) | Building config for EL 8, 9, Debian 12, and Ubuntu 22.04/24.04 OSS |
| [`build/pro.yml`](https://github.com/pgsty/pigsty/blob/v3.7.0/conf/build/pro.yml) | Building config for EL 7-10, Ubuntu, Debian pro version             |
