<div dir="ltr"><div class="gmail_quote">On Sun, May 16, 2010 at 10:36 AM, Steve Singer <span dir="ltr"><<a href="mailto:ssinger@ca.afilias.info">ssinger@ca.afilias.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im">Gurjeet Singh wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi All,<br>
<br>
The docs here <a href="http://www.slony.info/documentation/triggers.html" target="_blank">http://www.slony.info/documentation/triggers.html</a> says that post Postgres 8.3 version<br>
<br>
<snip><br>
<br>
* If you take a pg_dump of a Slony-I node, and drop out the Slony-I<br>
namespace, this now cleanly removes /all/ Slony-I components,<br>
leaving the database, /including its schema,/ in a "pristine",<br>
consistent fashion, ready for whatever use may be desired. <br>
</snip><br>
<br>
But I see that when dumping a schema containing tables monitored by Slony, the dump still shows the log triggers on those tables.<br>
</blockquote>
<br></div>
When it says 'drop out' it means use the 'DROP SCHEMA' postgresql command to drop out the slony schema this will remove your triggers. This only works with Slony1 2.0.0 or above (You were probably reading the 2.0.3 documentation on the website). This is the same procedure you need to use against a master with 1.2 (but with 2.0 it works against both slaves and masters).<br>
<br>
In 1.2.x slony munges the catalog on the slaves and dropping the slony schema from a slave will leave your leave in a bad state.<br>
<br>
If your planning on using Slony 2.0.x you are better off with the tip of REL_2_0_STABLE from cvs versus 2.0.3 due to the 'invalid utf8' bug fixed a few weeks ago.<br>
<br>
Does the attached documentation patch make that paragraph more clear?<div><div></div><div class="h5"><br></div></div></blockquote><div><br>The doc-patch does make it more clear, but I don't think <span style="font-family: courier new,monospace;">DROP SCHEMA _slony_cluster_name CASCADE</span> is something I'd like to do with my running Slony replication. A cleaner way would be more desirable.<br>
<br>Regards,<br></div></div>-- <br>gurjeet.singh<br>@ EnterpriseDB - The Enterprise Postgres Company<br><a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br><br>singh.gurjeet@{ gmail | yahoo }.com<br>
Twitter/Skype: singh_gurjeet<br>
<br>Mail sent from my BlackLaptop device<br>
</div>