PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

Unfortunately, our first order of business is to break the entire cluster. The key-value layer is essential to storing the cluster definition, as well as ensuring that only one PostgreSQL server ever wins the leadership race. It's one element that is not optional, and, as a result, we must shut down all of our Patroni instances in order to swap out all key-value references at once.

While we suggest stopping the leader node last, this is not entirely essential. However, avoiding needless failovers is always beneficial to cluster health.

Next, we need to remove the etcd and corresponding host line from the Patroni stampede.yml configuration file. We can then add equivalent consul and host lines that inform Patroni to use Consul ...