Andrew Sullivan wrote:
> 
> On Fri, May 09, 2008 at 12:46:22PM -0700, ajcity wrote:
>> 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?
> 
> When you subscribe Z to the cluster, it will get a current version of the
> database.
> 
> A
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 

Got it. found a way around it which might not be very elegant but works.
I dropped the clusters on X and Y, set the IP of X to Z so Z reads the old
IP of X (which has a public IP assigned to it; thats the main reason I
wanted to change the IPs), gave X a new IP.
Then I subscribed Z to Y and subscribed X to Y with the provider as Z.
So far it seems to be working; I guess I'll raise this topic again if I have
anyother problem with it

  Thanks

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