On Sun, May 14, 2006 at 10:37:34AM +1200, Glen Eustace wrote: > I need to regularly snap shot our production database on to my > development platform. This database is a slony master. What is the > recommended way to do this. I don't want any of the slony stuff in the > clone after the copy. > > I have been trying to use dump/restore and then delete cascade the slony > schema but there must be a cleaner way to do this.
That's the cleanest way I know of, at least until dump lets you exclude specific schemas. As long as your slaves are caught up (meaning the log tables are small) it shouldn't be too much overhead to load the slony stuff and then just drop it. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
