[pgpool-general: 3485] Re: pgpool for master-slave streaming replication in stream mode for HA , Load balancing and Replication.

[Alex Toth]

Hi Gurunadh,

It is possible to fail over for any kind of master failure, hardware or 
software.  I suggest you start with the file pgpool.conf.sample-stream 
in the source code bundle because it is close to what you seem to want 
to do.  Also, if you haven't looked already, 
http://www.pgpool.net/docs/latest/pgpool-en.html#stream has more 
information on failover with streaming replication, especially the 
failover_command, which is the final piece you need.


   alex

On 2/20/15 20:55, Gurunadh Venkata wrote:
> Hi all,
>
> I have query regarding pgpool.
>
> First i have setup the streaming replication on two machines.Now i 
> want the pgpool to look after the avialblity of two machines are up 
> and running.For this i am going to install pgpool on both master and 
> slave.i will write a failover.sh  script in both the master and slave 
> where if master is not available then slave should act as a master. Is 
> this possible in the case where the hardware crash of the Master server.
>
> Can We setup the Pgpool for both master and slave Server.
>
>
>
>
>
>
>
>
> Thanks & Regards,
> G V Gurunadh.
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150225/d091c1c4/attachment.htm>