Adding PostgreSQL to cluster management
By now, we've fulfilled a fairly long series of prerequisites simply to add PostgreSQL to the list of services managed by Pacemaker. We're over halfway through the chapter and are just now getting to the parts relevant to a PostgreSQL DBA. If you're new to DBA work, this might come as quite a shock, but it comes with the territory.
Once we add this resource, Pacemaker will be capable of starting and stopping everything necessary to run a PostgreSQL server. We'll still need to add several more elements to control factors such as the start order and associated services, but we've reached a critical juncture. We are very close to having a highly-available PostgreSQL cluster.
In this recipe, we'll discuss the steps required to add PostgreSQL itself to Pacemaker control.
Getting ready
As we're continuing to configure Pacemaker, make sure you've followed all the previous recipes.
How to do it...
Perform these steps on any Pacemaker node as the root user:
- Add a...
