What is the proper backup routine to create a slony-free dump of a database
so that I can restore a complete copy of the database and the schema on a
separate machine with no hint of slony ever having been there?  Ideally, in
a single file, just like you would have when running pg_dump without the =
=ADa
option.

I have used slony1_clean_schema.sh to create a separate schema file, then
created a data only dump, but in order to load my database, I need to then
drop all the indices and triggers, load the data, and then re-add them.
This is incredibly inconvenient and not at all ideal for any sort of
real-world environment.

This seems like it should be a trivially simple thing to do, but I can=B9t
find information about it anywhere.

Thanks for any help you can provide,
Aaron
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080320/=
13f07024/attachment-0001.htm