[pgpool-general: 5743] Re: "Return" node automatically
pengbo at sraoss.co.jp
Fri Sep 22 13:47:06 JST 2017
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"
Try to use "pcp_recovery_node" to recovery the node as standby in your follow_master
I attached my follow_master script.
On Thu, 14 Sep 2017 17:55:37 +0200
Giancarlo Celli <giancarlocelli at gmail.com> wrote:
> thanks for your help.
> I'm sending you pgpool.conf file and follow_master script.
> Let me know, please.
> Best regards.
> 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...
Size: 1714 bytes
Desc: not available
More information about the pgpool-general