unable to dump database, toast errors

From: Lonni Friedman <lfriedman(at)vasoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: unable to dump database, toast errors
Date: 2003-04-03 04:33:59
Message-ID: 3E8BB9B7.6080406@vasoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,
I'm running postgresql-7.2.1 on Redhat-7.2, and when attempting to
perform a dump with the command:
pg_dump -Ft -b -o DB_NAME > /tmp/db.tar

it chugs away for a few minutes, and then dies with the following error:

pg_dump: dumping out the contents of table artifact_file
pg_dump: ERROR: unexpected chunk number 0 (expected 1) for toast value
7685119
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "artifact_file"
failed: PQendcopy() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY
"artifact_file" WITH OIDS TO stdout;
pg_dump: *** aborted because of error

I've tried running vacuumdb as follows:
vacuumdb -z -v -a -f

and its come up clean every time, so i'm really at a loss on how to
resolve this. If it matters, the artifact_file table has 782 rows, and
is comprised of text and integer datatype columns.

Any suggestions would be greatly appreciated. thanks!

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-03 04:37:39 Re: pgsql password when FreeBSD boots -- what's usual?
Previous Message Dennis Gearon 2003-04-03 04:21:36 length of login names