<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><div><span>Please don't reply off list.</span></div><div><span><br></span></div><div><span>First check the version of the slony binaries installed across your servers, and the slonik tool you are using are the same and the version you want to be using. Then run update functions as follows.<br></span></div><div><br><span></span></div><div><span>http://slony.info/documentation/2.1/stmtupdatefunctions.html<br></span></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span
style="font-weight:bold;">From:</span></b> Lakshmi Priya <gangulynj@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> Glyn Astill <glynastill@yahoo.co.uk> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, 11 April 2012, 10:44<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Slony1-general] Error in slony<br> </font> </div> <br><div id="yiv382290251">How to run the Update functions..<br><br><div class="yiv382290251gmail_quote">On Wed, Apr 11, 2012 at 1:56 PM, Glyn Astill <span dir="ltr"><<a rel="nofollow" ymailto="mailto:glynastill@yahoo.co.uk" target="_blank" href="mailto:glynastill@yahoo.co.uk">glynastill@yahoo.co.uk</a>></span> wrote:<br><blockquote class="yiv382290251gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><div style="font-size:12pt;font-family:Courier New, courier, monaco, monospace, sans-serif;"><div><span>It means that the version of the functions in your schema does not match the compiled version of slony. I'm guessing you need to run "update functions"<br>
</span></div><div><br><blockquote style="border-left:2px solid rgb(16,16,255);margin-left:5px;margin-top:5px;padding-left:5px;"> <div style="font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt;"> <div style="font-family:times new roman, new york, times, serif;font-size:12pt;">
<div dir="ltr"> <font face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Lakshmi Priya <<a rel="nofollow" ymailto="mailto:gangulynj@gmail.com" target="_blank" href="mailto:gangulynj@gmail.com">gangulynj@gmail.com</a>><br> <b><span style="font-weight:bold;">To:</span></b> <a rel="nofollow" ymailto="mailto:slony1-general@lists.slony.info" target="_blank" href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a> <br>
<b><span style="font-weight:bold;">Sent:</span></b> Wednesday, 11 April 2012, 8:24<br>
<b><span style="font-weight:bold;">Subject:</span></b> [Slony1-general] Error in slony<br> </font> </div><div class="yiv382290251im"> <br><div><font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap;">Can any one say what this error meant..??</span></font><div>
<font color="#222222" face="arial, sans-serif"><span style="white-space:nowrap;"><br>
</span></font></div><div><span style="color:rgb(34,34,34);font-size:13px;font-family:arial, sans-serif;"><stdin</span><span style="color:rgb(34,34,34);font-size:13px;font-family:arial, sans-serif;">>:8: loading of file /usr/local/pgsq</span><span style="color:rgb(34,34,34);font-size:13px;font-family:arial, sans-serif;">l/share//slony1</span><span style="color:rgb(34,34,34);font-size:13px;font-family:arial, sans-serif;">_funcs.sql: PGRES_FATAL_ERR</span><span style="color:rgb(34,34,34);font-size:13px;font-family:arial, sans-serif;">OR ERROR: Slonik version: 2.0.6 != Slony-I version in PG build 2.1.1.</span>
</div>
</div><br></div>_______________________________________________<br>Slony1-general mailing list<br><a rel="nofollow" ymailto="mailto:Slony1-general@lists.slony.info" target="_blank" href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><a rel="nofollow" target="_blank" href="http://lists.slony.info/mailman/listinfo/slony1-general">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
<br><br> </div> </div> </blockquote></div> </div></div></blockquote></div><br>
</div><br><br> </div> </div> </blockquote></div> </div></body></html>