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 a 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¹t find information about it anywhere. Thanks for any help you can provide, Aaron
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
