On 10/25/06, Hanks, Dan <[EMAIL PROTECTED]> wrote: > > Hi folks, > > I have a 3-node cluster: node1 replicates to node 2, which replicates to > node 3. > > I would like to reverses that flow, such that node3 replicates to node2, > which replicates to node1. > > Here's my plan, I'm hoping for some feedback on whether it will work or not. > > 1) I run move set to move the origin from node 1 to node 3 > 2) I run subscribe set to have node 2 pull updates from node 3 > 3) I run subscribe set again to have node 1 pull from node 2. > > Will that work?
It should. However, why don't you 1) Subscribe 3 to 1 2) Subscribe 2 to 3 3) Move set to 3 4) Subscribe 1 to 2 Which will certainly get you the results you want, and in a very predictable, easy to understand way. _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
