<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hey All,<div><br></div><div>I have a general question about if I can slony use for the following situation.</div><div><br></div><div><br></div><div>I need to replicate a group of tables from server A to server B once a week (once a day for other tables). </div><div>This is because for this application they prepare the data during the days and at some point it needs to get</div><div>pushed out to server B.</div><div><br></div><div>Currently I have done using a a simple cron job that executes a stored procedure that copies</div><div>all data with DBLINK from server A to server B.</div><div><br></div><div>The problem is that if the schema changes I need to change it at 3 locations, storedprocedure where</div><div>I execute DBLINK, server A and server B. To eliminate changing the stored procedure</div><div>I was thinking to use slony with the below slonik commands. Server B only handle select statements for reporting.</div><div><br></div><div><br></div><div><br></div><div><font class="Apple-style-span" face="Courier">create set ( id = 998, origin = 1, comment = 'Temporary set' );</font></div><div><font class="Apple-style-span" face="Courier">set add table ( set id = 998, origin = 1, id = 5, full qualified name = 'Table A', comment = '' );</font></div><div><font class="Apple-style-span" face="Courier">set add table ( set id = 998, origin = 1, id = 6, full qualified name = 'Table B', comment = '' );</font></div><div><span class="Apple-style-span" style="font-family: Courier; ">... more tables</span></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">subscribe set ( id = 998, provider = 1, receiver = 2, forward = yes);</font></div><div><font class="Apple-style-span" face="Courier">sync (id=1);</font></div><div><font class="Apple-style-span" face="Courier">wait for event (origin=1, confirmed=2, wait on=1);</font></div><div><font class="Apple-style-span" face="Courier">merge set (id=1, add id = 998, origin=1); </font></div><div><font class="Apple-style-span" face="Courier"><br></font></div><div><font class="Apple-style-span" face="Courier">set drop table (origin = 1, id = 3);</font></div><div><font class="Apple-style-span" face="Courier">sync (id=1); </font></div><div><br></div><div><br></div><div>Would that be a good idea using slony or are there other tools that are more suited for this job?</div><div><br></div><div>Ries</div></body></html>