<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">So everything was fine, replicating etc and I restarted postgres and<br>
now I've got these errors.<br>
<br>
WARNING: table [id,nsp,name]=[116,publishers,dcm] - sl_table does not<br>
match pg_class/pg_namespace<br>
WARNING: table [id,nsp,name]=[117,reportlogs,dcm] - sl_table does not<br>
match pg_class/pg_namespace<br>
WARNING: Mismatch found between sl_table and pg_class. Slonik<br>
command REPAIR CONFIG may be useful to rectify this.<br>
<br></blockquote><div><br></div><div>I believe these errors are after up-gradation. You can run the health_check function on the nodes and if error found, try to do REPAIR CONFIG as mentioned in logs.</div><div><br></div>
<div><div class="gmail_quote"><div><a href="http://slony.info/documentation/2.1/stmtrepairconfig.html">http://slony.info/documentation/2.1/stmtrepairconfig.html</a></div></div><div><br></div>Health_check Function:</div><div>
<br><a href="http://slony.info/documentation/2.1/function.slon-node-health-check.html">http://slony.info/documentation/2.1/function.slon-node-health-check.html</a><br clear="all"></div><div><br></div><div>-- <br>Regards<div>
Raghav</div><div>Blog: htt://<a href="http://raghavt.blogspot.com/" target="_blank">raghavt.blogspot.com/</a></div></div><div><br></div><div><br></div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
This is postgres 9.1.4 and slony 2.1.1.<br>
<br>
I don't know what could be wrong, seriously it was fully replicated<br>
until I restarted postgres just a few minutes ago.<br>
<br>
We did an upgrade a week or so back from 8.4 to 9.1, using slon, and<br>
switchover from one host to this host worked flawless, but now, what<br>
exactly is it saying?<br>
<br>
Thanks<br>
Tory<br>
<br>
Fedora<br>
Postgres_9.1.4<br>
Slon.2.1.1<br></blockquote><div><br></div></div>