[Pgcluster-general] recommendations needed

[David Koski]

I need a master-master solution for postgresql and I am not
sure pgcluster is the right choice.  The application is for
mission critical server that is required to keep a network of
wireless access points on line. I have recently installed a
backup server for failover. When the primary server goes down
the backup takes over. But it is necessary that the two servers
have their databases synchronized. I am considering the following
solution: Server1 (the primary server) will have a Cluster DB
and Load Balancer. Server2 (the backup failover server) will
have a Cluster DB and the Replicator. In case Server1 fails,
server2 will have the current database state. To bring server1 on
line after failure, the database of server2 will be exported and
imported to server1. The problem is if server1 goes down then
server will not be able to function because the Load Balancer
will be down. And no matter what server the Load Balancer is on,
the system will fail if it goes down. What is needed is redundance
not just of the Cluster DB but of the access mechanism---in this
case the Load Balancer.

Your input is appreciated.

Regards,
David Koski
david at kosmosisland.com