PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

For these steps, assume eth0 is the primary network interface and 10.0.0.10 is the IP we are trying to claim. Follow these steps to move or create a virtual IP:

1. First, connect to the PostgreSQL node that had the IP address earlier. This is often the primary server.
2. Release the IP address with the following command:

sudo ip addr del 10.0.0.10/32 dev eth0

3. Ping the desired IP address with the following command:

ping -c 3 10.0.0.10

4. If the preceding command reaches a PostgreSQL server, connect to that system and repeat step 2 to step 3.
5. Next, connect to the new server that should own the IP address.
6. Claim the IP address with the following command:

sudo ip addr add 10.0.0.10/32 dev eth0 label eth0:pgvip

7. Tell the network about ...