[pgpool-general: 2351] Re: PGPool in HA Setup Question

[Athanasios | ZenGuard]

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?


On Thu, Dec 19, 2013 at 12:34 PM, Aleksander Englert <
aleksander_englert at skg.pl> wrote:

>  Yes, it is possible :).
>
> http://www.pgpool.net/pgpool-web/contrib_docs/watchdog/en.html
>
> I implemented this and it work fine.
>
> W dniu 2013-12-19 12:24, Athanasios | ZenGuard pisze:
>
> Dear list,
> 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:
> 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:
> 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.
>
>  Is such a setup possible? If yes, has anyone implemented it in the past?
> Any gotchas or pointers are more than welcome.
>
>
> _______________________________________________
> pgpool-general mailing listpgpool-general at pgpool.nethttp://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
> --
> Pozdrawiam / Best regards
> Aleksander Englert
> aleksander_englert at skg.pl
> tel. 033/8281168
> kom. +48692469269
>
> SKG S.A.
> 43-309 Bielsko-Biała, Al. Armii Krajowej 336
> tel. +48 33 8281-100, fax +48 33 8281-105
> e-mail: firma at skg.pl
>
> Nr KRS: 47940, Sąd Rejonowy w Bielsku-Białej, VIII Wydział Gospodarczy KRS
> NIP: 547-12-57-936, Regon: 070711270
> Kapitał zakładowy: 500 000 zł w całości opłacony
>
> Niniejsza wiadomość może zawierać informacje prawnie chronione. Wiadomość
> skierowana jest wyłącznie do
> adresata/ adresatów określonych wyżej i stanowi własność nadawcy.
> Odbiorca, który otrzymał tę wiadomość
> przypadkowo, proszony jest o jej nie rozpowszechnianie, a następnie
> poinformowanie nadawcy i jej
> usunięcie. Rozpowszechnianie, kopiowanie, ujawnianie lub przekazywanie
> osobom trzecim w jakiejkolwiek
> formie informacji zawartych w niniejszej wiadomości w całości lub części
> jest zakazane.
>
> The information contained in this message may be privileged and
> confidential and protected from disclosure.
> Information included in that message is addressed only to the
> addressee/addressees determined above and is the property
> of the sender. If you have received this communication in error, please
> notify the sender immediately by replaying
> to the message and deleting it from your computer. Any dissemination,
> distribution or copying of this communication
> to the third parties is strictly prohibited.
>
> _______________________________________________
> 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.sraoss.jp/pipermail/pgpool-general/attachments/20131219/3b11ba86/attachment.html>