PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For this recipe, we will need at least three PostgreSQL servers. As before, we'll assume they are named pgha1, pgha2, and pgha3, all of which exist on the 10.0.30.x subnet. Follow these steps on all three servers except where indicated:

1. Use pip to install Patroni by running the following commands as a root-capable user:

sudo pip3 install -r /path/to/requirements.txt
sudo pip3 install patroni

2. Execute this command to find where the PostgreSQL binaries are stored:

pg_config --bindir

3. Now, create a configuration directory for Patroni, which is owned by the postgres user:

sudo mkdir /etc/patroni
sudo chown postgres:postgres /etc/patroni

4. As the postgres user, continue by creating a file named stampede.yml in the /etc/patroni ...