Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux