missing chunk number 0 for toast value ...

Поиск
Список
Период
Сортировка
От MIlos Prudek
Тема missing chunk number 0 for toast value ...
Дата
Msg-id 200605032202.57825.prudek@bvx.cz
обсуждение исходный текст
Ответы Re: missing chunk number 0 for toast value ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hello postgres wizards :-)

I have a problem with table info:

select * from info;
ERROR:  missing chunk number 0 for toast value 190937

Dumping does not work either:

pg_dump db >db.unl
pg_dump: ERROR:  missing chunk number 0 for toast value 190937
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "info" failed: PQendcopy()
failed.
pg_dump: Error message from server: pg_dump: The command was: COPY public.info
(idsection, idinfo, txt) TO stdout;

I googled, and using advice in an archived post I run the following command:
 select relname from pg_class where oid =
 (select reltoastrelid from pg_class where relname = 'info');

which resulted in one row with value pg_toast_61934

and then I ran

reindex table pg_toast.pg_toast_61934;

but it did not help.

What should I do to salvage the table?

--
Milos Prudek

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

Предыдущее
От: "Hogan, James F. Jr."
Дата:
Сообщение: audit table containing Select statements submitted
Следующее
От: Tom Lane
Дата:
Сообщение: Re: missing chunk number 0 for toast value ...