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:46:26 |
Message-ID: | 3E8BBCA2.4050800@vasoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Greetings,
Apologies if this comes through twice.
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 | Dennis Gearon | 2003-04-03 04:50:59 | storage, entry, display of dates with/out time zone |
Previous Message | Sean Chittenden | 2003-04-03 04:38:04 | Re: pgsql password when FreeBSD boots -- what's usual? |