missing chunk number 0 for toast value when pg_dump??

From: Yi Zhao <yi(dot)zhao(at)alibaba-inc(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: missing chunk number 0 for toast value when pg_dump??
Date: 2008-08-03 09:25:24
Message-ID: 1217755524.5247.3.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi, all:
I use pg_dump command to dump a specified table:
pg_dump mydb -p 5555 -Uyahoo -t mytable -D -a > /export/dump.sql

but, I got this:
-----------------------
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: missing chunk number 0 for
toast value 14319826
pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor
-----------------------

the table have about 3,000,000 records, but from the dump file, I got
only 300,000 records with "INSERT INTO".

my postgresql version is :8.3.3.

thanks a lot.

regards,

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2008-08-03 10:12:12 bytea encode performance issues
Previous Message Marco Bizzarri 2008-08-03 07:50:21 Re: Advice on implementing counters in postgreSQL