>
> So everything was fine, replicating etc and I restarted postgres and
> now I've got these errors.
>
> WARNING:  table [id,nsp,name]=[116,publishers,dcm] - sl_table does not
> match pg_class/pg_namespace
> WARNING:  table [id,nsp,name]=[117,reportlogs,dcm] - sl_table does not
> match pg_class/pg_namespace
> WARNING:  Mismatch found between sl_table and pg_class.  Slonik
> command REPAIR CONFIG may be useful to rectify this.
>
>
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.

http://slony.info/documentation/2.1/stmtrepairconfig.html

Health_check Function:

http://slony.info/documentation/2.1/function.slon-node-health-check.html

-- 
Regards
Raghav
Blog: htt://raghavt.blogspot.com/





> This is postgres 9.1.4 and slony 2.1.1.
>
> I don't know what could be wrong, seriously it was fully replicated
> until I restarted postgres just a few minutes ago.
>
> We did an upgrade a week or so back from 8.4 to 9.1, using slon, and
> switchover from one host to this host worked flawless, but now, what
> exactly is it saying?
>
> Thanks
> Tory
>
> Fedora
> Postgres_9.1.4
> Slon.2.1.1
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20120713/99918e92/attachment.htm