roctaiwan <nettreeinc at gmail.com> writes:
> Ok I have received this error today, can anybody tell me why is it happening?
> and how can I fix it? looks like it has something to do with cache, but I
> have set my cache 256mb in postgresql.conf, isn't it not enough?
>
> contactdb=# copy contact from '/home/postgres/5m.copy';
> ERROR:  cache lookup failed for type 58783
> CONTEXT:  SQL statement "INSERT INTO _sql_cluster.sl_log_1 (log_origin,
> log_xid, log_tableid, log_actionseq, log_cmdtype, log_cmddata) VALUES (1,
> $1, $2, nextval('_sql_cluster.sl_action_seq'), $3, $4);"

The database looks pretty mussed up if parts of relations are missing.

I'd concur with Glyn that you probably need to reconstruct that
would-be subscriber from scratch (likely from the point of running
"initdb"), as well as that it would be useful to figure out what
caused the database to be corrupted.

Slony-I shouldn't be able to do so.

The amount of cache is pretty irrelevant to the matter.
-- 
(reverse (concatenate 'string "ofni.sailifa.ac" "@" "enworbbc"))
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"