<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Gurunadh,<br>
<br>
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, <a class="moz-txt-link-freetext" href="http://www.pgpool.net/docs/latest/pgpool-en.html#stream">http://www.pgpool.net/docs/latest/pgpool-en.html#stream</a>
has more information on failover with streaming replication,
especially the failover_command, which is the final piece you
need.<br>
<br>
<br>
alex<br>
<br>
On 2/20/15 20:55, Gurunadh Venkata wrote:<br>
</div>
<blockquote
cite="mid:CAJAdScYC_rRhsNLnfGV691ZLufZsUO+skh1wnbAzmJKF60x8Xg@mail.gmail.com"
type="cite">
<div dir="ltr">Hi all,
<div><br>
</div>
<div>I have query regarding pgpool.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Can We setup the Pgpool for both master and slave Server.</div>
<div><br>
</div>
<div><br>
</div>
<div> <br clear="all">
<div>
<div class="gmail_signature">
<div dir="ltr"><br>
<br>
<br>
<br>
<br>
Thanks & Regards,<br>
G V Gurunadh.</div>
</div>
</div>
</div>
<img moz-do-not-send="true" src="http://s.bl-1.com/hDfTzhm.gif"
height="1" width="1"></div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<br>
</body>
</html>