<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi lk,<div class=""><br class=""></div><div class="">I can comment on some of these... pgpool can be configured in many different combinations. I am using a dual server setup with both servers running pgpool and postgresql with replication and load balancing enabled. if pgpool fails on the server acting as the main/master pgpool server, then it fails over to the other. The pgpool slave takes over and brings up an interface with the same IP that pgpool uses. Both postgres servers are used for writes and either server is used for reads.</div><div class=""><br class=""></div><div class="">1. pgpool has a watchdog feature that talks to other pgpool servers</div><div class="">2. the watchdog triggers scripts that you configure to bring interfaces up/down as need be</div><div class="">3. multipl pgpool servers with multiple postgresql backend db servers</div><div class="">4. can't comment... no windows for me</div><div class=""><div class="">
<div style="color: rgb(0, 0, 0); font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; border-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-stroke-width: 0px;"><br class="Apple-interchange-newline">Cheers,<br class="">Gervais</span></div>
</div>
<br class=""><div style=""><blockquote type="cite" class=""><div class="">On Jul 29, 2015, at 11:37 AM, lk gen <<a href="mailto:lkgen11@gmail.com" class="">lkgen11@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><span style="font-size:12.8000001907349px" class="">Hi,</span><div style="font-size:12.8000001907349px" class=""><br class=""></div><div style="font-size:12.8000001907349px" class=""> I have some questions about pgpool:</div><div style="font-size:12.8000001907349px" class=""><br class=""></div><div style="font-size:12.8000001907349px" class="">1. Does PG pool use a witness server? how does PGPool prevents split-brain situations</div><div style="font-size:12.8000001907349px" class="">2. Suppose there was an automatic failover, can the application use the same IP/port address as before the failover? what is the mechanism for that?</div><div style="font-size:12.8000001907349px" class="">3, How do you prevent a single point of failure when connecting to the pgpool?</div><div style="font-size:12.8000001907349px" class="">4. How difficult is it to port PGPool to Windows</div><div style="font-size:12.8000001907349px" class=""><br class=""></div><div style="font-size:12.8000001907349px" class="">Regards</div><div class="yj6qo ajU" style="font-size:12.8000001907349px"><div id=":1q0" class="ajR" tabindex="0"><img class="ajT" src="https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif"></div></div><span class="adL HOEnZb" style="font-size:12.8000001907349px"><font color="#888888" class=""> lk</font></span></div>
_______________________________________________<br class="">pgpool-general mailing list<br class=""><a href="mailto:pgpool-general@pgpool.net" class="">pgpool-general@pgpool.net</a><br class="">http://www.pgpool.net/mailman/listinfo/pgpool-general<br class=""></div></blockquote></div><br class=""></div></body></html>