Help! pg_dump: Error message from server: ERROR: cache lookup failed for type 19

From: 夏武 <xia(dot)wu(dot)cn(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Help! pg_dump: Error message from server: ERROR: cache lookup failed for type 19
Date: 2010-09-11 06:21:31
Message-ID: AANLkTikFqmOg2S6CwLp3K4difxoAH8C2p3XjpD50V5tp@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i use the slony for replication of postgresql database. it work fine some
day.
After i use the slony command to delete the replication node, pg_dump does
not work, the error message is:
*pg_dump: schema with OID 73033 does not exist*

Then i delete the name space of slony in pg_namespace, and pg_dump does not
work.
So i delete the data of the name space in pg_class, pg_type, the command is:
*DELETE FROM pg_class where relnamespace=73033*
*DELETE FROM pg_type where relnamespace=73033*

i got the error message:
pg_dump: Error message from server: ERROR: cache lookup failed for type 19

How to fix it? How to recovery the database?
thanks!

wu.xia

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2010-09-11 10:09:33 Re: SQL Programming Question
Previous Message John R Pierce 2010-09-11 04:14:33 Re: SQL Programming Question