[pgpool-general: 3122] Re: online recovery

[Kent Tong]

thanks for the clarification! Then I will probably just do it with plain
ssh and shell script, as invoking a remote shell script through PostgreSQL
seems a bit too much trouble.


On Sat, Aug 30, 2014 at 6:07 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:

> > Hi,
> >
> > is there any advantage of online recovery when compared to doing it "by
> > hand", eg, recovering the host and attaching it again?
>
> For streaming replication configuration, online recovery just
> automates the recovery operation thus essentially there's no
> advantage in on line recovery except:
>
> - pgpool-II automatically determines the primary node
>
> - it attaches the node as soon as possible after the recovery completes
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>



-- 
Kent Tong
IT author and consultant, child education coach
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140830/2128557e/attachment.html>