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

[Tatsuo Ishii]

I suggest you get support from EDB first since they provide a support
service for pgpool-II as well if you purchase PPAS.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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.