PGSQL Basic

Basic primary-replica postgres cluster setup

Singleton

Let’s start with the simplest case.

  1. pg-test:
  2.   hosts:
  3.     10.10.10.11: { pg_seq: 1, pg_role: primary }
  4.   vars:
  5.     pg_cluster: pg-test

Use the following command to create a primary database instance on the 10.10.10.11 node.

  1. bin/createpg pg-test

M-S Replication

Pigsty natively supports M-S replication, e.g., to declare a typical one primary & one replica HA database cluster.

  1. pg-test:
  2.   hosts:
  3.     10.10.10.11: { pg_seq: 1, pg_role: primary }
  4.     10.10.10.12: { pg_seq: 2, pg_role: replica }
  5.   vars:
  6.     pg_cluster: pg-test

Use bin/createpg pg-test to create the cluster. If you have already finished deploying 10.10.10.11 in step 1 singleton deployment, you can also use bin/createpg 10.10.10.12 to expand the cluster.

Last modified 2022-06-04: fii en docs batch 2 (61bf601)