<div dir="ltr"><div dir="auto">Thanks a lot! </div><div>Can I know what pcp_recovery_node does exactly?</div><div><span style="color:rgb(33,33,33);white-space:pre-wrap">How does it perform recovery?</span><br></div><div>It not runs recovery_1st_stage.sh....so what does it do?</div><div>Thanks a lot.</div><div> Best regards!</div><div><br></div><div>Giancarlo Celli</div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">Il 28 Set 2017 02:33, "Bo Peng" <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>> ha scritto:<br type="attribution"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
If you need recovery the backend node first,<br>
you need to use "pcp_recovery_node".<br>
<br>
If the backend node is already started as a standby,<br>
you can use "pcp_attach_node"to let Pgpool-II know the node.<br>
<br>
Therefore you can just add "pcp_attach_node" in your origin script.<br>
<br>
On Mon, 25 Sep 2017 15:38:00 +0200<br>
Giancarlo Celli <<a href="mailto:giancarlocelli@gmail.com" target="_blank">giancarlocelli@gmail.com</a>> wrote:<br>
<br>
> Hi,<br>
><br>
> I've used "pcp_recovery_node" to recovery the node as standby in my<br>
> follow_master script and it's working now!<br>
> I've a question for you: why use pcp_recovery_node and not pcp_attach_node?<br>
> What is the difference?<br>
> Thanks a lot!<br>
> Best regards.<br>
><br>
> Giancarlo<br>
><br>
> 2017-09-22 6:47 GMT+02:00 Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>>:<br>
><br>
> > Hi<br>
> ><br>
> > I confirmed your follow_master script.<br>
> ><br>
> > I think you should use "pcp_recovery_node" command to<br>
> > recovery the backend as standby.<br>
> ><br>
> > I didn't see your initiate_replication.sh,<br>
> > but I think because the backend node is already detached<br>
> > while you use "initiate_replication.sh" to recovery the backend node.<br>
> ><br>
> > Even if the backend is started after recovery, Pgpool-II<br>
> > can not know the node. That's the reason why you need to do "Return"<br>
> > by pgpoolAdmin.<br>
> ><br>
> > Try to use "pcp_recovery_node" to recovery the node as standby in your<br>
> > follow_master<br>
> > script.<br>
> ><br>
> > I attached my follow_master script.<br>
> ><br>
> > On Thu, 14 Sep 2017 17:55:37 +0200<br>
> > Giancarlo Celli <<a href="mailto:giancarlocelli@gmail.com" target="_blank">giancarlocelli@gmail.com</a>> wrote:<br>
> ><br>
> > > Hi,<br>
> > ><br>
> > > thanks for your help.<br>
> > > I'm sending you pgpool.conf file and follow_master script.<br>
> > > Let me know, please.<br>
> > > Best regards.<br>
> > > Giancarlo<br>
> > ><br>
> > ><br>
> > > 2017-09-14 14:52 GMT+02:00 Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>>:<br>
> > ><br>
> > > > Hi,<br>
> > > ><br>
> > > > By me the "follow_master_command" works.<br>
> > > > After failover, "follow_master_command" called pcp_recovery_node<br>
> > > > command to recovery the slave node to the new primary node, and<br>
> > > > "Return" is not needed.<br>
> > > ><br>
> > > > Can I have your pgpool.conf and follow_master script configured<br>
> > > > in the follow_master_command?<br>
> > > ><br>
> > > > On Mon, 11 Sep 2017 11:38:40 +0200<br>
> > > > Giancarlo Celli <<a href="mailto:giancarlocelli@gmail.com" target="_blank">giancarlocelli@gmail.com</a>> wrote:<br>
> > > ><br>
> > > > > Hi to all.<br>
> > > > ><br>
> > > > > I would like to know how to do a "Return" node just gets detected by<br>
> > > > pgpool.<br>
> > > > > Specifically, I've created a follow_master_command that, after a<br>
> > > > failover,<br>
> > > > > performs recovery of all standby nodes to hook them to the new<br>
> > primary<br>
> > > > > master. Everything works, but then I have to click "return" on<br>
> > > > pgpooladmin<br>
> > > > > to complete the procedure. I need to make the "return" automatically.<br>
> > > > ><br>
> > > > > Can you help me, please?<br>
> > > > > Attached is the image of the pgpooladmin who asks for the Return<br>
> > > ><br>
> > > ><br>
> > > > --<br>
> > > > Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
> > > > SRA OSS, Inc. Japan<br>
> > > ><br>
> > > ><br>
> ><br>
> ><br>
> > --<br>
> > Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
> > SRA OSS, Inc. Japan<br>
> ><br>
<br>
<br>
--<br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
<br>
</blockquote></div></div>
</div>