<div dir="ltr">Thank you for the quick reply Aleksander. I would prefer to avoid watchdog mode in PGPool and do it via VRRP, if that is possible. Any pointers to that direction?</div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Thu, Dec 19, 2013 at 12:34 PM, Aleksander Englert <span dir="ltr"><<a href="mailto:aleksander_englert@skg.pl" target="_blank">aleksander_englert@skg.pl</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"><div class="im">
Yes, it is possible :). <br>
<br>
<a href="http://www.pgpool.net/pgpool-web/contrib_docs/watchdog/en.html" target="_blank">http://www.pgpool.net/pgpool-web/contrib_docs/watchdog/en.html</a><br>
<br>
I implemented this and it work fine.<br>
<br>
<div>W dniu 2013-12-19 12:24, Athanasios |
ZenGuard pisze:<br>
</div>
</div><blockquote type="cite">
<div dir="ltr">Dear list,
<div><div class="h5"><div>thanks of all thanks for all the hard work and the valuable
support from the PGPool community. I am using PGPool to do
statement based replication between 2 postgresql 9.3
databases. So far it works fine but pgpool by itself is a
single point of failure. My question is the following:</div>
<div>Is it possible to run 2 instances on pgpool on two
different hosts and do an active/passive failover scenario
using VRRP? To elaborate a bit:</div>
<div>The 2 hosts share one virtual IP that is only active on one
at a time. The application points to that virtual IP, as
opposed to the physical IP of one of the two PGPool hosts.
When one of the PGPools die, the other one grabs the IP and
continues to seamlessly serve connections towards the two
databases.</div>
<div><br>
</div>
<div>Is such a setup possible? If yes, has anyone implemented it
in the past? Any gotchas or pointers are more than welcome.</div>
</div></div></div>
<br>
<fieldset></fieldset>
<br><div><div class="h5">
<pre>_______________________________________________
pgpool-general mailing list
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</div></div></blockquote><div><div class="h5">
<br>
<div>-- <br>
Pozdrawiam / Best regards<br>
Aleksander Englert<br>
<a href="mailto:aleksander_englert@skg.pl" target="_blank">aleksander_englert@skg.pl</a><br>
tel. 033/8281168<br>
kom. <a href="tel:%2B48692469269" value="+48692469269" target="_blank">+48692469269</a><br>
<br>
SKG S.A. <br>
43-309 Bielsko-Biała, Al. Armii Krajowej 336<br>
tel. <a href="tel:%2B48%2033%208281-100" value="+48338281100" target="_blank">+48 33 8281-100</a>, fax <a href="tel:%2B48%2033%208281-105" value="+48338281105" target="_blank">+48 33 8281-105</a><br>
e-mail: <a href="mailto:firma@skg.pl" target="_blank">firma@skg.pl</a><br>
<br>
Nr KRS: 47940, Sąd Rejonowy w Bielsku-Białej, VIII Wydział
Gospodarczy KRS<br>
NIP: 547-12-57-936, Regon: 070711270<br>
Kapitał zakładowy: 500 000 zł w całości opłacony<br>
<br>
Niniejsza wiadomość może zawierać informacje prawnie chronione.
Wiadomość skierowana jest wyłącznie do<br>
adresata/ adresatów określonych wyżej i stanowi własność nadawcy.
Odbiorca, który otrzymał tę wiadomość<br>
przypadkowo, proszony jest o jej nie rozpowszechnianie, a
następnie poinformowanie nadawcy i jej<br>
usunięcie. Rozpowszechnianie, kopiowanie, ujawnianie lub
przekazywanie osobom trzecim w jakiejkolwiek<br>
formie informacji zawartych w niniejszej wiadomości w całości lub
części jest zakazane.<br>
<br>
The information contained in this message may be privileged and
confidential and protected from disclosure.<br>
Information included in that message is addressed only to the
addressee/addressees determined above and is the property<br>
of the sender. If you have received this communication in error,
please notify the sender immediately by replaying<br>
to the message and deleting it from your computer. Any
dissemination, distribution or copying of this communication<br>
to the third parties is strictly prohibited. </div>
</div></div></div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>