On Fri, Jan 16, 2009 at 8:31 AM, Kevin Kempter <[email protected]> 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. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
