<div dir="ltr"><div style="font-family:arial,sans-serif;font-size:12.727272033691406px"><br></div><div class="gmail_extra"><div class="gmail_quote">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-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;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><span style="font-size:12.727272033691406px;font-family:arial,sans-serif">Whenever a new </span><span class="" style="font-size:12.727272033691406px;font-family:arial,sans-serif">node</span><span style="font-size:12.727272033691406px;font-family:arial,sans-serif"> is attached to pgpool-II using the </span><span class="" style="font-size:12.727272033691406px;font-family:arial,sans-serif">pcp_attach_node</span><span style="font-size:12.727272033691406px;font-family:arial,sans-serif"> utility. pgpool-II forgets the previous primary </span><span class="" style="font-size:12.727272033691406px;font-family:arial,sans-serif">node</span><span style="font-size:12.727272033691406px;font-family:arial,sans-serif"> and start searching for primary </span><span class="" style="font-size:12.727272033691406px;font-family:arial,sans-serif">node </span><span style="font-size:12.727272033691406px;font-family:arial,sans-serif">again. The first </span><span class="" style="font-size:12.727272033691406px;font-family:arial,sans-serif">node</span><span style="font-size:12.727272033691406px;font-family:arial,sans-serif"> which fulfils the conditions for being the primary </span><span class="" style="font-size:12.727272033691406px;font-family:arial,sans-serif">node</span><span style="font-size:12.727272033691406px;font-family:arial,sans-serif"> is selected as primary. </span></div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><div><div><div>
<br></div>Is there an option in pcp_attach_node to specify if promotion should happen or not?<br><br></div></div></div></blockquote><div>There is currently no option available in pcp_attach_node to stop or enforce node promotions<span style="font-size:12.727272033691406px;font-family:arial,sans-serif">. And it is the user's </span><span style="font-size:12.727272033691406px;font-family:arial,sans-serif">responsibility that the </span><span class="" style="font-size:12.727272033691406px;font-family:arial,sans-serif">node</span><font face="arial, sans-serif"> is in appropriate condition (in this case </font><span style="font-size:12.727272033691406px;font-family:arial,sans-serif">standby server, not primary), for pgpool-II to recognise it as primary or standby node.</span></div>
<div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><div><div></div>
I am using pgpool from ubuntu 14.04 distro, which is 3.3.2 I think.<br><br></div>Long<br><br><div><div><div><div><div>
<div class="gmail_extra"><br>
<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
Date: Tue, 1 Jul 2014 12:48:31 -0700<br>
From: Santosh Mathew <<a href="mailto:santosh.checkmail@gmail.com" target="_blank">santosh.checkmail@gmail.com</a>><br>
To: <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
Subject: [pgpool-general: 3000] Can backend0 be a slave ?<br>
Message-ID:<br>
<CA+Q=<a href="mailto:xBjjdUEhQ89JvYv96znPTAPv5Y1NiunA4UsTT-EZQ8mvxw@mail.gmail.com" target="_blank">xBjjdUEhQ89JvYv96znPTAPv5Y1NiunA4UsTT-EZQ8mvxw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi,<br>
<br>
I have 3 postgres nodes in streaming replication mode with two pgpools in<br>
active -stanby configuration.<br>
<br>
Is my observation right that pgpool always looks at backend0 as the master<br>
? Supposing there is a failure in backend0 and backend1 is promoted as the<br>
new master. In this case if we are able to fix backend0 and attach it back<br>
as the slave of the new master (backend1), pgpool still assumes that<br>
backend0 is the master and tries to write to it. Is there a configuration<br>
setting to tell pgpool that backend0 is a slave and backend1 is a master ?<br>
<br>
Thanks in advance for your help.<br>
<br>
- Santosh<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140701/ec0ab742/attachment.html" target="_blank">http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140701/ec0ab742/attachment.html</a>><br>
<br>
------------------------------<br>
<br>
</blockquote></div><br></div></div></div></div></div></div></div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div></div>