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      jnasby at pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461