Thanks, I found it. Looks like it will do exactly what I need.

Mike

From: Vick Khera <vivek at khera.org<mailto:vivek at khera.org>>
Date: Tuesday, November 12, 2013 at 10:52 AM
To: Mike James <mjames at profitpoint.com<mailto:mjames at profitpoint.com>>
Cc: "slony1-general at lists.slony.info<mailto:slony1-general at lists.slony.info>" <slony1-general at lists.slony.info<mailto:slony1-general at lists.slony.info>>
Subject: Re: [Slony1-general] removing slony for dev database

Search the archives for a script called slony1_extract_schema.sh which does this for you.



On Tue, Nov 12, 2013 at 10:01 AM, Mike James <mjames at profitpoint.com<mailto:mjames at profitpoint.com>> wrote:
I did a pg_dump -s --exclude-schema=_slony_cluster db_name > outfile.ddl   And I'm restoring it to a server that I intend to use for dev testing. I don't need any of the slony objects for testing, is there a way to remove all of the slony1 objects in the dev database? No slon daemons running on the dev box. This is slony1-2.0.3. The production server is ubuntu 8.04, postgresql 8.3 and the dev server is ubuntu 12.04, postgres 9.3.1.

Thanks,
Mike

_______________________________________________
Slony1-general mailing list
Slony1-general at lists.slony.info<mailto:Slony1-general at lists.slony.info>
http://lists.slony.info/mailman/listinfo/slony1-general


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20131112/117942c6/attachment.htm