On Jun 29, 2007, at 6:58 AM, Filip Rembiałkowski wrote:

> To produce a "clean" dump ( that is, without Slony-I schema and
> triggers ) we have to install temporary backup node, wait for it to
> catch up, DROP NODE it , and dump it.  Whole process takes almost
> twice longer as plain pg_dump (and is more failure-prone)

I do a "plain" pg_dump on the origin node.

To restore, I run pg_restore -l to generate a list of objects,  
comment out anything inside the _REPLICATION schema and any non-data  
resources, then restore into a clean schema generated via the script  
Jan created to make the clean schema :-)