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 ...
|
Список | 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 по дате отправления: