[pgpool-general: 5743] Re: "Return" node automatically

[Bo Peng]

Hi

I confirmed your follow_master script.

I think you should use "pcp_recovery_node" command to 
recovery the backend as standby.

I didn't see your initiate_replication.sh, 
but I think because the backend node is already detached 
while you use "initiate_replication.sh" to recovery the backend node.

Even if the backend is started after recovery, Pgpool-II 
can not know the node. That's the reason why you need to do "Return"
by pgpoolAdmin.

Try to use "pcp_recovery_node" to recovery the node as standby in your follow_master 
script.

I attached my follow_master script.

On Thu, 14 Sep 2017 17:55:37 +0200
Giancarlo Celli <giancarlocelli at gmail.com> wrote:

> Hi,
> 
> thanks for your help.
> I'm sending you pgpool.conf file and follow_master script.
> Let me know, please.
> Best regards.
> Giancarlo
> 
> 
> 2017-09-14 14:52 GMT+02:00 Bo Peng <pengbo at sraoss.co.jp>:
> 
> > Hi,
> >
> > By me the "follow_master_command" works.
> > After failover, "follow_master_command" called pcp_recovery_node
> > command to recovery the slave node to the new primary node, and
> > "Return" is not needed.
> >
> > Can I have your pgpool.conf and follow_master script configured
> > in the follow_master_command?
> >
> > On Mon, 11 Sep 2017 11:38:40 +0200
> > Giancarlo Celli <giancarlocelli at gmail.com> wrote:
> >
> > > Hi to all.
> > >
> > > I would like to know how to do a "Return" node just gets detected by
> > pgpool.
> > > Specifically, I've created a follow_master_command that, after a
> > failover,
> > > performs recovery of all standby nodes to hook them to the new primary
> > > master. Everything works, but then I have to click "return" on
> > pgpooladmin
> > > to complete the procedure. I need to make the "return" automatically.
> > >
> > > Can you help me, please?
> > > Attached is the image of the pgpooladmin who asks for the Return
> >
> >
> > --
> > Bo Peng <pengbo at sraoss.co.jp>
> > SRA OSS, Inc. Japan
> >
> >


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
-------------- next part --------------
A non-text attachment was scrubbed...
Name: follow_master.sh
Type: text/x-sh
Size: 1714 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170922/42ccee5f/attachment.bin>