On Jan 11, 2008, at 9:34 AM, 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?
your schema is mucked about by slony, so when you restore, you may not
get what you expect to get in terms of triggers, rules, etc.
I sometimes take a clean schema dump (with slony stuff removed) from
the master, and data-only dump from the replica, then use the
pg_restore -l and -L options to prune what gets restored (ie, comment
out all the slony related stuff).
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
