PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For this recipe, we will need at least three PostgreSQL servers. For demonstration purposes, we'll assume they are named pgha1 (10.0.30.1), pgha2 (10.0.30.2), and pgha3 (10.0.30.3). Follow these steps on all three servers except where indicated:

1. Extract the files in the etcd binary distribution and install the necessary files with the following commands as a root-capable user:

tar -xf etcd-v3.3.18-linux-amd64.tar.gz
sudo cp etcd-v3.3.18-linux-amd64/etcd* /usr/local/bin

2. Create a storage directory for etcd with these commands as a root-level user:

sudo mkdir /db/etcd
sudo chown postgres:postgres /db/etcd

3. Create a file named /etc/etcd.conf on the pgha1 server with the following content:

name: pgha1 data-dir: /db/etcd initial-advertise-peer-urls: ...