[pgpool-general: 3476] Re: Hot stand by streaming replication and pgpool setup
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.
SRA OSS, Inc. Japan
> 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
> 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.
More information about the pgpool-general