I am attempting to set up PGSQL-HA streaming replication on freeBSD 8.2 (willing to upgrade to 8.4 if need be).
The set up is simple: 2 nodes, one active one standby. I have successfully set up streaming replication between the two nodes, but I am now trying to set up a resource agent/manager to deal with automatic failover and STONITH.
I have attempted to use Heartbeat/Corosync/Pacemaker for this, but am running into difficulty building them from source (Pacemaker, in particular).
Is there an easier way than using Pacemaker for a simple 2 node set up? I have little experience with this and especially with freeBSD.
*Note: FreeBSD 8.x is required, the servers are running other services that would make it too difficult to upgrade or change the OS