<div dir="ltr">Search the archives for a script called slony1_extract_schema.sh which does this for you.<div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Nov 12, 2013 at 10:01 AM, Mike James <span dir="ltr"><<a href="mailto:mjames@profitpoint.com" target="_blank">mjames@profitpoint.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="font-size:14px;font-family:Calibri,sans-serif;word-wrap:break-word">
<div>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.</div>
<div><br>
</div>
<div>Thanks,</div>
<div>Mike</div>
</div>
<br>_______________________________________________<br>
Slony1-general mailing list<br>
<a href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br>
<a href="http://lists.slony.info/mailman/listinfo/slony1-general" target="_blank">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
<br></blockquote></div><br></div>