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

Поиск
Список
Период
Сортировка
От 夏武
Тема Help! pg_dump: Error message from server: ERROR: cache lookup failed for type 19
Дата
Msg-id AANLkTikFqmOg2S6CwLp3K4difxoAH8C2p3XjpD50V5tp@mail.gmail.com
обсуждение исходный текст
Ответы Re: Help! pg_dump: Error message from server: ERROR: cache lookup failed for type 19  (Craig Ringer <craig@postnewspapers.com.au>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: SQL Programming Question
Следующее
От: Martin Gainty
Дата:
Сообщение: Re: SQL Programming Question