On Fri, Jan 11, 2008 at 09:34:24AM -0500, Bill Moran wrote: > > I do this quite frequently (to grab data out of our production environment > to our lab for testing purposes, for example). I've yet to see any > problems ... what is it that's supposed to go awry when I do this? > What is the danger?
Slony has fooled with the catalog tables. You get an unrestorable dump. Some versions of pg_dump actually won't dump as a result of this -- they notice the problem, and quit. There's a tool that ships with Slony that is supposed to allow dumping on a replica. It doesn't seem to have had a lot of testing. It'd be nice to get some reports of its utility and reliability. A _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
