Glyn Astill a écrit : > Hi people, > > I'm setting us up a separate staging / test server and I want to read in a > pg_dump of our current origin stripping out all the slony stuff. > > I was thinking this could serve two purposes a) test out backups restore > properly and b) provide us with us with the staging / test server > > What's the best way to remove all the slony bits? > > I was thinking read in the dump, then use uninstall node - but I'd rather not > have to run the slon daemons.
You don't have to run any slon daemon to execute uninstallnode(). You just have to execute something like "select _YOURINSTANCE.uninstallnode()" on the newly restored DB. You can the drop the entire schema (drop schema _YOURINSTANCE cascade). > > Or should I just leave all the slony stuff in there... would it cause us any > problems? There'd be no slons running and the next night it's all wiped and > restored again... Not sure leaving all slony stuf is really a good option as it does : - modify the catalog schema - log every modification in data as slony triggers will stay up and active. > > Anyone got any ideas? Anyone got something similar already? I do restore the whole master db and uninstall/drop every slony stuff. Best regards, -- Stéphane SCHILDKNECHT Président de PostgreSQLFr Tél. 09 53 69 97 12 http://www.postgresql.fr _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
