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!
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 |