<div dir="ltr"><div class="gmail_quote">On Tue, May 18, 2010 at 10:55 PM, Jan Wieck <span dir="ltr"><<a href="mailto:JanWieck@yahoo.com">JanWieck@yahoo.com</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">On 5/16/2010 8:22 AM, 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>
I think you misinterpret the statement.<br>
<br>
If you take a complete dump of all schemas, restore that and THEN drop the slony schema, you have a pristine stand alone system as the result.<br>
<br>
pg_dump does not exclude cross-schema definitions like those triggers. You will get the same for example with foreign keys. For a table in the schema you are dumping, that references a table in a non-dumped schema, pg_dump will still emit the ALTER TABLE attempting to create the constraint.<br>
<br clear="all"></blockquote><div><br>Makes sense now. But I guess the statement should have read like this:<br><br><snip><br>
<br>
* If you restore a backup of a Slony-I node (taken by pg_dump or any other method), and drop 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><br>Regards, <br></div></div><br>-- <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>