<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="">Hi All,<div class=""><br class=""></div><div class="">I have a two servers setup using pgpool. Both have pgpool and postgresql installed on them and it is setup as a load balancing and replication.</div><div class=""><br class=""></div><div class="">I have tested everything and it seems to work just fine. I have one question about recovering a downed backend postgresql node. I have had a few instances where I am hammering the db cluster and it never closes a connection and therefore pcp_recovery times out and fails after it has completed stage 1. If I run pcp_recovery and it does not complete, is it safe to run it again to recover? In my testing it seems to work fine. My concern is that I leave the working postgres server in a state that it should not be in. I’m a bit of a postgresql newbe, but I’m learning. Is there a danger that my main (and only remaining) copy of the db could get corrupted or experience data loss? </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; border-spacing: 0px;"><br class="Apple-interchange-newline">Cheers,<br class="">Gervais</span></div>
</div>
<br class=""></div></body></html>