<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hi,</div><div><br></div><div>I've got 1 master and 3 slaves. I am using Slony 1.2.22.</div><div><br></div><div>We are in Production and for one of the slaves we decided to remove a few tables from replication only on one slave.</div><div>So the same tables will be replicated on the two others slaves.</div><div><br></div><div>I had a look on Slony documentation at http://slony.info/documentation/1.2/dropthings.html and I came to the conclusion</div><div>that it shoud be possible to do it using the "old way"</div><div><br></div><div>I mean using sections # 15.4.2 and # 15.5 to do something like BUT ONLY ON THIS SLAVE NOT ON THE TWO OTHER SLAVES<br></div><div><br></div><pre class="PROGRAMLISTING"> select _slonyschema.alterTableRestore(40);
select _slonyschema.tableDropKey(40);
delete from _slonyschema.sl_table where tab_id = 40;</pre><div><br>We can not drop the set and build the subscription because it takes a lot of time to build subscription for the entire set. We are on production and our clients are connected.<br></div><div><br></div><div>Feel free to tell me if this method is safety.</div><div><br></div><div>Thanks.</div><div><br></div><div>Kind regards.<br></div><div><br></div><div></div></div></body></html>