<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Tue, Jul 15, 2014 at 9:22 AM, Muhammad Usama <span dir="ltr"><<a href="mailto:m.usama@gmail.com" target="_blank">m.usama@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div style="font-family:arial,sans-serif;font-size:12.7273px"><br></div><div class="gmail_extra">
<div class="gmail_quote"><div class="">On Wed, Jul 2, 2014 at 10:45 PM, Long On <span dir="ltr"><<a href="mailto:on.long.on@gmail.com" target="_blank">on.long.on@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div><div><div>Hello,<br><br></div>I am also observing node 0 being promoted to master when using pcp_attach_node, after a recovery of node 0. Node 1 is master and should remain so but I see a failback sequence happening in pgpool.log. After which write statements are no longer possible since pgpool is sending them to node 0, which is now standby.<br>
</div></div></div></div></blockquote><div> </div></div><div><span style="font-size:12.7273px;font-family:arial,sans-serif">Whenever a new </span><span style="font-size:12.7273px;font-family:arial,sans-serif">node</span><span style="font-size:12.7273px;font-family:arial,sans-serif"> is attached to pgpool-II using the </span><span style="font-size:12.7273px;font-family:arial,sans-serif">pcp_attach_node</span><span style="font-size:12.7273px;font-family:arial,sans-serif"> utility. pgpool-II forgets the previous primary </span><span style="font-size:12.7273px;font-family:arial,sans-serif">node</span><span style="font-size:12.7273px;font-family:arial,sans-serif"> and start searching for primary </span><span style="font-size:12.7273px;font-family:arial,sans-serif">node </span><span style="font-size:12.7273px;font-family:arial,sans-serif">again. The first </span><span style="font-size:12.7273px;font-family:arial,sans-serif">node</span><span style="font-size:12.7273px;font-family:arial,sans-serif"> which fulfils the conditions for being the primary </span><span style="font-size:12.7273px;font-family:arial,sans-serif">node</span><span style="font-size:12.7273px;font-family:arial,sans-serif"> is selected as primary.</span></div>
</div></div></div></blockquote><div> <br></div></div>Muhammad, what are the conditions pgpool looks for to decide if a node is primary or standby?<br><br></div><div class="gmail_extra">Thanks,<br></div><div class="gmail_extra">
Long<br><br></div></div>