[pgpool-general: 3475] Hot stand by streaming replication and pgpool setup

[Gurunadh Venkata]

Hi all,

I am new to the pgpool.

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.

His requirement is Load should balanced on both the nodes and if master
node fails then standby should switch to Master.

Till Hot-stand by streaming replication i have done the setup and it is
working fine.

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.

Server details
Master server 10.0.0.81
slave Sever    10.0.0.82
pgpool running on 10.0.0.81
EDB version PPAS 9.4
Pgpool version 3.4




Thanks & Regards,
G V Gurunadh.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150217/b426f282/attachment.html>