[ Thanks to Falko
Timme for this link. ]
“This article explains how to set up (and monitor) an
Active/Passive PostgreSQL Cluster, using Pacemaker with Corosync
and DRBD. Prepared by Rafael Marangoni, from BRLink Servidor Linux
Team.“Introduction
“We use two nodes, one active (that answers requests from apps)
and the other on passive mode. If the active server is down, the
passive one will automatically take its position (being the active
node).“1 Preliminary Note
“Linux Distribution:
“We are using the CentOS 5.5 (64bits) distribution, but it will
probably work on Fedora (and Red Hat, for sure) as well. The
installation of the CentOS is very simple and classical, select the
base packages and other stuff that you like/need. One issue that
must be remembered is that we use DRBD to replicate the PostgreSQL
data between the nodes, then you’ll need to have a disk or
partition exclusive to DRBD. Remember this before partitioning
disks on CentOS installation.”