<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>
<br></div>Is there an option in pcp_attach_node to specify if promotion should happen or not?<br><br></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:1px solid 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">santosh.checkmail@gmail.com</a>><br>
To: <a href="mailto:pgpool-general@pgpool.net">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">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>