[pgpool-general: 4506] Re: pgpool unable to attach a node during failback command

[Shay Cohavi]

Hi,
Thanks for your replay...
I do use online recovery in case a full recovery is needed (using
pg_basebackup - via pcp_recovery_node).
but I added an ability to perform a switchover between the nodes using
stop/detach primary - failover occurs and reattach it as secondary (using
failback script).
but as the failback finished the pgpool does not attach it as secondary!!


Can you please advice?

cohavisi


On Tue, Mar 1, 2016 at 10:41 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> You should use online recovery instead of pcp_attach_node.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
> > Hi,
> > I have a Hugh problem regarding attaching a node (as secondary) to the
> pool
> > after I performing pcp_attach_node.
> >
> > after failover is being completed successfully and valid primary node is
> > active, i'm performing an *pcp_attach (via sql)* to the faulty node in
> > order to failback as secondary!
> >
> > *select pcp_attach_node (0,'10.10.61.99',1200,9898,'*****','*****') *
> >
> > during this command, a failback script is being executed and performs the
> > following:
> > 1. rsync between the DB nodes.
> > 2. create recovery.conf.
> > 3. startup the node(as secondary).
> >
> > *the failback could take for 20 min to finish.*
> >
> > after the failback finished *successfully* (exit status 0) and the node
> > started as *secondary* (according to postgres) - streaming replication.
> >
> > *the pgpool reportes the node status from 1 to 3 (instead of 2).*
> >
> > *** when failback finished early (less then few min) the pgpool reports
> the
> > node status as 2 - as aspected.*
> >
> >
> > please advice regarding this issue...
> >
> >
> > *Thanks,*
> > *cohavisi*
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160301/46b936d4/attachment.html>