[Pgcluster-general] pgcluster and Red Hat Cluster Services

[Sean Brown]

We use Red Hat Cluster Services on our machines for NFS services. We  
are planning on using pgcluster for HA of our PostgreSQL database. We  
have only 2 nodes that will run the DB, load balancer and replication  
servers. I have seen that there has been some problems getting a load  
balancer to fail over and I can not see how to run it with a shared  
cluster IP.

Has anyone used RHCS to manage running the load balancer and have it  
handle failover? If not, how would I have the load balancer listen on  
a cluster IP?

The proposed setup is:

(The systems all have DNS names)
Production Network IP: 10.10.0.0/16
Node 1: 10.10.0.20
Node 2: 10.10.0.21
Cluster IP: 10.10.0.22

Node 1 and Node 2 have a private network between them (192.168.0.0/24)  
that the replication server will use to talk between the nodes. What I  
want is to be able to have our application use 10.10.0.22 to talk  to  
the load balancer since that IP is managed by RHCS and will move from  
one node to the other as needed in the event of node failures.