You guess right : my purpose is precisly to add a new slave and drop the old one. Of course, i stop replication process before performing so. What are the kind of 'all replication information ' i can loose? So far, i can't see what it implies...
My first step would to retrieve my primary dabase just as before it was instrumented by slony. So i can have a 'virgin dump' and restore it in any not replicated architecture. My second step would be to restart on entirely new replication with a new configuration by creating a new cluster and so on. Btw, on my opinion, bare-metal functions are not really industrial. I have to supply an integrated solution to a system operator. I would rather think of using perl commands just by switching through differents slon_tool.conf. Any comments on this appoach? thanks. 2008/2/27, "Stéphane A. Schildknecht" < [EMAIL PROTECTED]>: > > lio bod a écrit : > > Hello world, > > > > I'm trying some procedures to modify a cluster : my need is to change > > the slave host (same base, same name, same model...) for a given master > > base master host. > > > > I had a look on slonik_uninstall_nodes command and i wonder why the doc > > (http://www.slony.info/documentation/adminscripts.html) tells it is 'a > > /VERY/ unsafe script' > > > > I'd like to know why it's supposed to be so unsafe? > > > > Any better practice? > > Any best practice? > > > > Thx, > > It is unsafe because it drops all replication information from all nodes > involved. You then lose your replication network in a single operation. Be > sure > it won't break your databases, but you will lose your replication. > > If your need is to add a new slave and drop the old one, you'd better have > a > look at bare-metal functions. > > something like "select _INSTANCE.uninstallnode()" on the old slave should > do > the work. You could also execute some drop node procedure on a "specific" > node, > which is not, what the perl script you invoked does. > > You could have a look at slonik_drop_node also. You just should verify > twice > you will execute that script against the right node :-) > > Regards, > > -- > Stéphane SCHILDKNECHT > Président de PostgreSQLFr > Tél. 09 53 69 97 12 > http://www.postgresqlfr.org >
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
