> 
>> Ok. Sounds like it might work but what if I wanted to change the IP of
>> machineZ to that of machineX and vice versa cos I wanna remove the public
>> IP
>> on machineX and set it for machineZ; can I do this without disturbing
>> Slony
>> or do I have to consult the network admin?
> 
> No, that won't work.  You'll confuse Slony.  It will be surprised that
> records it thought got to one database never made it there at all.  Don't
> try to subvert Slony's controls by cute work-arounds.  They almost always
> break things.  (This is a significant source of much of the trouble that
> some users end up having, in fact.  Slony is complicated enough without
> you
> trying to outsmart it.)
> 

Point taken!!
But am a bit concerned since postgres on machineZ is fresh without any data
in it and there have been several rows of replicated data on machineX. Will
MOVE SET automatically cause all the data to be added into the postgres on
machineZ?

  Victor




-- 
View this message in context: http://www.nabble.com/Need-help-on-changing-Slave-node-and-adding-another-slave-node-tp17146792p17155273.html
Sent from the Slony-I -- General mailing list archive at Nabble.com.