PostgreSQL High Availability Cookbook - Second Edition

How to do it...

For this recipe, we will need two PostgreSQL servers, pg1 and pg2, where pg1 is the currently active node. Follow these steps as the root user on the system indicated to move an active PostgreSQL service from one node to another:

1. Stop the PostgreSQL service with pg_ctl on pg1:

        pg_ctl -D /db/pgdata stop -m fast

2. Unmount the /db filesystem on pg1:

        umount /db

3. Mark the VG_POSTGRES group as inactive using vgchange on pg1:

        vgchange -a n VG_POSTGRES

4. Demote the DRBD status to secondary with drbdadm on pg1:

        drbdadm secondary pg

5. Promote the DRBD status to primary with drbdadm on pg2:

        drbdadm primary pg

6. Mark the VG_POSTGRES group as active using vgchange on pg2:

        vgchange -a y VG_POSTGRES

7. Mount the /db filesystem ...