We would like to install postgresql to our servers to server our webpage.
We have the following architecture :
2 load balancer (supermicro P4, 3GRAM, 200GB RAID disk), 2 systemx ibm 3650 server (48GRAM/server), 1 ibm ds3400 shared storage.
The shared storage has redundant controllers and the storage is connected to the servers through redundant optical cable. The loadbalancer is redundant too. The load balancers choose the less loaded server to serve the webpage requests.
The system is working, the shared storage is working, the web load balancing is working. I need some help only for installing postgresql.
I have gone throught the postgresql documentation as I see there is two clustering solution.
- pgpool ([login to view URL])
- pgcluster ([login to view URL])
What I need :
- one ip address/port to connect from webapplication
- two postgresql server running on the 2 ibm server accesing the same database stored on the shared storage.
- redundant load balancing
I need somebody who has experience to install postgresql cluster in same architecture. I need advice and help to install the postgres server. I would like to install if it's possible so I need a "howto"...
anyway, if you has experience and you can install the system, contact me and we will discuss to process.