<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;">
<div>Thanks, I found it. Looks like it will do exactly what I need. </div>
<div><br>
</div>
<div>Mike</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<span style="font-weight:bold">From: </span>Vick Khera <<a href="mailto:vivek@khera.org">vivek@khera.org</a>><br>
<span style="font-weight:bold">Date: </span>Tuesday, November 12, 2013 at 10:52 AM<br>
<span style="font-weight:bold">To: </span>Mike James <<a href="mailto:mjames@profitpoint.com">mjames@profitpoint.com</a>><br>
<span style="font-weight:bold">Cc: </span>"<a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>" <<a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a>><br>
<span style="font-weight:bold">Subject: </span>Re: [Slony1-general] removing slony for dev database<br>
</div>
<div><br>
</div>
<div>
<div>
<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>
</div>
</div>
</span>
</body>
</html>