Home >> pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 43712886 in pg_toast_16418

pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 43712886 in pg_toast_16418

0 Person had this question Me Too

After

$ pg_dumpall -U postgres -f /tmp/pgall.sql

I see following:

pg_dump: SQL command failed pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 43712886 in pg_toast_16418 pg_dump: The command was: COPY public.page_parts (id, name, filter_id, content, page_id) TO stdout; pg_dumpall: pg_dump failed on database "radiant", exiting

I haven't earlier backups. How can I fix it?

Thanks in advance.

All Replies
  • Magnus Hagander replied on 10/19/2012 12:40:44 PM

    This means that your database is basically corrupt, for some reason.

    What you need to do is try to access the table page_parts piece by piece (one row at a time), to determine which row is corrupt, and then delete the row. The probably easiest way to do this is to do a SELECT * FROM page_parts LIMIT , and do that as a binary search over the rows in the table (start at the middle, cutting each piece in half etc). Once you've identified the row, delete it, and you should be able to dump the rest of the database. Once you have the row you can also identify which individual column it is, of course, if the data is high value.

    Was this helpful?
    Yes
    0
  • 1

Share Your Answer: pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 43712886 in pg_toast_16418

*
*

Similar Questions