<div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div>Hi all,<br>
<br>
</div>I am new to the pgpool.<br>
<br>
</div>Now i want to show a demo to the client where PPAS is installed in
two machines and Streaming replication has been setup between those two
machines.<br>
<br>
</div>His requirement is Load should balanced on both the nodes and if master node fails then standby should switch to Master.<br>
<br>
</div>Till Hot-stand by streaming replication i have done the setup and it is working fine.<br>
<br>
</div>Please suggest me how to configure the pgpool + streaming
replication setup with load balancing feature and
Failover/Switchback.What parameters need's to be changed in pgpool side to achieve Load balancing and HA(failover/switchback) .I am planning
to install pgpool on the Master server itself.<br>
<br>
</div>Server details<br>
</div>Master server 10.0.0.81<br>
</div>slave Sever 10.0.0.82<br>
</div>pgpool running on 10.0.0.81<br>
</div>EDB version PPAS 9.4<br>
</div>Pgpool version 3.4<div><div class="gmail_signature"><div dir="ltr"><br><br><br><br>Thanks & Regards,<br>G V Gurunadh.</div></div></div>
</div>