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

[Duncan McQueen]

>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
>