<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">I have two servers running with replication, load balancing, watchdog (with virtual IP) enabled.<div class=""><br class=""></div><div class="">My plan is to remove any single point of failure from my database. The web sites I am running would point to the virtual interface’s IP on whatever is running as a primary in the pgpool and there would be two database servers behind the pool. Here is my setup as it stands:</div><div class=""><br class=""></div><div class="">dbserver0:</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>pgpool - get’s virtual IP if it starts first</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>postgres</div><div class=""><br class=""></div><div class="">dbserver1:</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>pgpool</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>postgres </div><div class=""><br class=""></div><div class="">I have everything working except that the there can be a situation where one of the pgpools starts up with a stale pgpool_staus file and it thinks a backend node is either up when it is down (or down when it is up). I am not sure how to sort this out as this file seems to only be written to when pgpool stops.</div><div class=""><br class=""></div><div class="">Can someone suggest how to sort this out. I know that you will likely need to review any number of config files and/or scripts in my configuration. Can you let me know what you would want to see before I sanitize them all and send them on.</div><div class=""><br class=""></div><div class="">Also, if my plan is completely off, I am open to any alternative suggestion as to how to best achieve my goal as described above.</div><div class=""><div class=""><div apple-content-edited="true" class="">
<span style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2;" class=""><br class="Apple-interchange-newline">Cheers,</span><br style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2;" class=""><span style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2;" class="">Gervais</span><br style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2;" class=""><span style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; orphans: 2; widows: 2; font-size: 11px;" class="">------------------------------------<br class="">Gervais de Montbrun</span><div class=""><span style="text-align: start; text-indent: 0px; orphans: 2; widows: 2;" class=""><span style="font-size: 11px;" class="">Systems Administrator</span><br class=""><span style="font-size: 11px;" class="">GTalk: <a href="mailto:gervais@silverorange.com" class="">gervais@silverorange.com</a></span></span></div>
</div>
<br class=""></div></div></body></html>