On Fri, May 09, 2008 at 05:22:44AM -0700, ajcity wrote:
> 
>  Hi all,
>   I have a slight issue and I need advice on what to do.
>   I already have a local machine (machineX) replicating from I remote
> server(machineY). Now, my company just got another server(machineZ) with
> higher config and I want to replicate the data on the machineX onto the
> machineZ then setup the new server to replicate from the machineY and the X
> should replicate from the machineY.

So you currently have Y->X, and you want to perform Y->X->Z, and then later
Y->Z->X?  

>   1) Can I just change the IP of machineX to the the IP of machineY,
> subscribe machineZ then replicate and when this is done, I should change the
> IP of machineZ to that of machineX, and then subscribe machineX with a
> different IP?
>   2) Or do I just pull-down the structure and start everything again from
> scratch with the appropriate config?

Don't do either.  Subscribe Z using provider X, and then later move the
subscription from X to Y, and then X's subscription from Y to Z.  This is
all part of the design of Slony.

A