<div dir="ltr"><span style="font-family:arial,sans-serif;font-size:13px">Hey,</span><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px"><div>I'm trying to set-up a ha PostgreSQL installation where there is 4 or more web servers and 2 or more PostgreSQL servers.</div>
<div><br></div><div>The PostgreSQL servers will run in master-salve replication mode and I would like pgpool to do failover and auto-recovery.</div><div><br></div><div>My knowledge of pgpool is limited so I have been doing alot of reading and looking through examples however every example I look at seems to have only 1 pgpool which to me just moves the point of failure onto pgpool.</div>
<div><br></div><div>My current thinking is I will install pgpool on each web server which will allow me to easily do connection pooling however I'm not sure if this will allow me to do auto-recovery and auto-failover as from what i read pgpool needs to be a "master" and with each web server having pgpool installed they will conflict when trying to change a slave to master or recover a new server.</div>
</div><div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Is this true or would I be able to install pgpool on each webserver without problems ?</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">my webservers and postgresl span multiple subnets so I am unable to create a virtual ip and just change it when pgpool goes down :(.</div>
<div style="font-family:arial,sans-serif;font-size:13px"><br></div><div style="font-family:arial,sans-serif;font-size:13px">Currently have postgresql version 9.1 install but can upgrade to 9.2<br></div><div style="font-family:arial,sans-serif;font-size:13px">
<br></div><div style="font-family:arial,sans-serif;font-size:13px">Cheers.</div><div style="font-family:arial,sans-serif;font-size:13px"><br></div>
</div>