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

[Tatsuo Ishii]

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