On 12-03-27 04:48 PM, Brian Trudal wrote:
> Hi there
>
> I couldn't get much info from docs; can someone explain what CLONE
> PREPARE does ? Essentially I wanted to clone a subscriber1 to new
> subscriber3; but wanted to confirm; after the clone prepare; does the
> first subscriber1 will stop replicating from origin or it will continue
> to replicate ?

The first subscriber will continue to replicate.

>
> What happens to other subscribers in the origin node if there are more
> than one subscribers already ?

Any other subscribers of the origin would be uneffected by cloning a 
subscriber.  Any paths between the subscriber you are cloning and other 
subscribers should also be cloned as part of the CLONE NODE.

>
> Also, do we need to skip the dumping of slony schema (_{clustername})
> during the dump + restore while cloning new subscriber ?
>

No you should include the slony schema of the node you are cloning in 
the dump.

http://git.postgresql.org/gitweb/?p=slony1-engine.git;a=blob;f=clustertest/disorder/tests/CloneNode.js;h=b191eac650c58bf40084eb08aa8b5371a708a69c;hb=refs/heads/REL_2_1_STABLE

The unit test above contains an example of using clone node.



> --
> brian
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general