PostgreSQL 12 High Availability Cookbook - Third Edition

Getting ready

This recipe depends on the presence of the entire stack. Please complete all of the previous recipes in this chapter before continuing.

We also need a broken server. The easiest way to do this is to break it ourselves. Execute these commands on any system to simulate an unrecoverable server crash:

pkill -9 patroni
pkill -9 postgres
find /db/pgdata -name '*r*' -o  -name '*0*' -delete

This will cause an unclean shutdown of both Patroni and PostgreSQL and remove several necessary files for the PostgreSQL service to operate.