From: | MIlos Prudek <prudek(at)bvx(dot)cz> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | missing chunk number 0 for toast value ... |
Date: | 2006-05-03 20:02:57 |
Message-ID: | 200605032202.57825.prudek@bvx.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-03 20:40:17 | Re: missing chunk number 0 for toast value ... |
Previous Message | Hogan, James F. Jr. | 2006-05-03 19:39:51 | audit table containing Select statements submitted |