[Pgpool-general] How to set up PGPool II Recovery

[Łukasz Jagiełło]

2008/7/9 Maxence DUNNEWIND <maxence at dunnewind.net>:
> Yes, pgpool is on the same host than backend1.
> I set the replication which seems to works perfectly well. I'm now
> trying to set up online recovery. When I start pgpool with -n -d
> options, I can see the healthcheck which detects when my banckend2 stops
> to work. It prints smthg like :
>
> 2008-07-09 08:52:18 DEBUG: pid 12406: starting health checking
> 2008-07-09 08:52:18 DEBUG: pid 12406: health_check: 0 the DB node
> status: 2
> 2008-07-09 08:52:18 DEBUG: pid 12406: health_check: 1 the DB node
> status: 3
>
> I guess the state '3' is when the backend failed to answer. Anyway, when
> the backend went back, the state doesn't change.
>
> Even after reading the informations from mailing list, I can't
> understant what's wrong.

Got same problem. Answer is 'pcp_recovery_node'.

-- 
Łukasz Jagiełło
G-Forces Web Management Polska

T: +44 (0) 845 055 9040
F: +44 (0) 845 055 9038
E: lukasz.jagiello at gforces.pl
W: www.gforces.co.uk

This e-mail is confidential and intended solely for the use of the
individual to whom it is addressed. If you are not the intended
recipient, please notify the sender immediately. Do not disclose the
contents of this e-mail to any other person, use it for any purpose,
print, copy, store, or distribute it. This e-mail should then be
destroyed. Any views expressed in this message are those of the
individual sender except where the sender specifically states them to
be the views of G-Forces Web Management Ltd. Registered Office: 4 & 5
Kings Row, Armstrong Road, Maidstone, Kent. ME15 6AQ. Registered
Company No. 3863609. VAT Registration No. 7250 384 50