Fixing up a corrupted toast table

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Fixing up a corrupted toast table
Date: 2006-02-17 05:55:24
Message-ID: 78A9FFF6-F468-46DD-BBEC-443A7268DB01@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have an older 7.4 installation which is giving this error
during pg_dump:

pg_dump: ERROR: missing chunk number 0 for toast value 25923965
pg_dump: SQL command to dump the contents of table "element"
failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR: missing chunk number 0 for
toast value 25923965

(slightly edited, but not in any significant way).

I believe that it's a known issue that occasionally causes this (this
is not a bug report, and I'm quite aware of point upgrades and so on)
and the server will likely be updated to 8.1.current within the month.

I'd like to make the current problem go away, though, perhaps by
deleting the relevant row in the element table. I'm not quite sure how
to go about that, though. Could anyone point me in the right direction?

Cheers,
Steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2006-02-17 05:58:02 Fwd: [pgsql-jp: 36715] Josh Berkus氏の講演MP3
Previous Message Christopher Browne 2006-02-17 05:52:28 Re: How do I use the backend APIs