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

Tatsuo Ishii ishii at postgresql.org
Wed Feb 18 09:59:59 JST 2015

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

> 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
> slave Sever
> pgpool running on
> EDB version PPAS 9.4
> Pgpool version 3.4
> Thanks & Regards,
> G V Gurunadh.

More information about the pgpool-general mailing list