From: MIlos Prudek <prudek@bvx.cz>
To: pgsql-admin@postgresql.org
Subject: missing chunk number 0 for toast value ...
Date: Wed, 3 May 2006 22:02:57 +0200
Message-ID: <200605032202.57825.prudek@bvx.cz> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: prudek@bvx.cz
Subject: Re: missing chunk number 0 for toast value ...
In-Reply-To: <200605032202.57825.prudek@bvx.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox