On Fri, Jan 16, 2009 at 8:31 AM, Kevin Kempter
<kevink at consistentstate.com> wrote:
> Hi all;
>
> anyone have any samples (or links to docs) per preparing and adding a new node
> to an existing SLONY cluster ?

first, install the *same* slony1 version on the new node.

create the DB, and load a copy of the exact same schema onto it
(without the slony stuff).  there is a script in the source
distribution that will extract the schema for you from the master
node..

next, run a slonik script to "store node" the new node, and "store
path" a path from every other node to and from this new node.

start running the slon daemon on the new node

run "subscribe set" to tell the new node to start replicating.

sit back and watch the replica copy data (you will have to watch the
logs because you won't see any data in the tables until the
transaction is complete).

have a beer/tea/whatever to celebrate.