[Pgpool-general] "Hot" adding a new node under pgpool-II

[Tatsuo Ishii]

Sample scripts are in the docs. See "online recovery" section in
pgpool-en.html.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> >From what I understand, setting up "online recovery" is pretty
> intensive - basically creating scripts that will repopulate the
> database - is this correct?  Or are there scripts provided that
> already will aid in doing "online recovery"?
> 
> On Tue, Sep 2, 2008 at 7:24 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> >> >From what I understand, pgpool-II has the ability to add a node
> >> without restarting pgpool?
> >
> > Yes.
> >
> >> I could not find information on how to
> >> accomplish this, especially if the IP or host of the node is unknown
> >> at the time you start pgpool.  What is the correct procedure to
> >> accomplish this?
> >
> > You need to set up the "Online recovery" setting (see docs for more
> > info).  Add the new node to pgpool.conf. Reload pgpool.conf. Shutdown
> > postmaster running on the new node. Do "online recovery". That's it.
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> >