PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For this recipe, we should already have three PostgreSQL servers. As usual, we'll assume they are named pgha1, pgha2, and pgha3. If pgha1 is the current primary, follow these steps to promote a different node to primary status:

1. Execute the following command as the postgres user to initiate a failover:

patronictl -d pgha1:2379 switchover stampede

2. Answer the presented prompts as directed.
3. Wait a few seconds before running this command as the postgres user:

patronictl -d pgha1:2379 list stampede