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

Aleksander Englert aleksander_englert at skg.pl
Thu Dec 19 20:34:44 JST 2013


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 list
> pgpool-general at pgpool.net
> http://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, Sa;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?os'ci op?acony

Niniejsza wiadomos'c' moz.e zawierac' informacje prawnie chronione. 
Wiadomos'c' skierowana jest wy?a;cznie do
adresata/ adresatów okres'lonych wyz.ej i stanowi w?asnos'c' nadawcy. 
Odbiorca, który otrzyma? te; wiadomos'c'
przypadkowo, proszony jest o jej nie rozpowszechnianie, a naste;pnie 
poinformowanie nadawcy i jej
usunie;cie. Rozpowszechnianie, kopiowanie, ujawnianie lub przekazywanie 
osobom trzecim w jakiejkolwiek
formie informacji zawartych w niniejszej wiadomos'ci w ca?os'ci lub 
cze;s'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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131219/c3c00d9d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3760 bytes
Desc: Kryptograficzna sygnatura S/MIME
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20131219/c3c00d9d/attachment.p7s>


More information about the pgpool-general mailing list