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 :-)
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
