On Wed, Feb 29, 2012 at 12:13 PM, Brian Trudal <dbrb2002-sql at yahoo.com> wrote:
> I have fairly large database (~1T) with few tables being replicated to other
> node in the cluster using slony 2.0.7. Now I wanted to add a fresh node with
> complete copy of the main master.
>
> So, whats the best recommended approach ? Clone (clone prepare, dump/load,
> clone finish ) or use the subscribe mode ? or any other alternative ?

Well, CLONE can only be done against a subscriber, not against the origin.

<http://slony.info/documentation/stmtcloneprepare.html>

That seems to rule out using it for the situation you describe.