From: Tom Lane <tgl@sss.pgh.pa.us>
To: Adam Witney <awitney@sgul.ac.uk>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: pg_dump error
Date: Wed, 07 Sep 2005 10:54:24 -0400
Message-ID: <27244.1126104864@sss.pgh.pa.us> (raw)
In-Reply-To: <BF447684.4C6C2%awitney@sgul.ac.uk>
References: <BF447684.4C6C2%awitney@sgul.ac.uk>
Adam Witney <awitney@sgul.ac.uk> writes:
> pg_dump: ERROR: unexpected chunk number 3292 (expected 5) for toast value
> 144391872
> pg_dump: SQL command to dump the contents of table "measured_bioassay_base"
> failed: PQendcopy() failed.
> Any ideas whats happened here?
If you're lucky, it's just a corrupted index on the toast table for
"measured_bioassay_base", in which case a REINDEX will fix it. You'll
need to look at the pg_class entry for "measured_bioassay_base" to find
out what the toast table's name is. Something like
regression=# select relname from pg_class where oid =
regression-# (select reltoastrelid from pg_class where relname = 'measured_bioa
ssay_base');
relname
-----------------
pg_toast_597768
(1 row)
regression=# reindex table pg_toast.pg_toast_597768;
REINDEX
I would be interested to see "pg_filedump -i -f" output for the toast
table's index before you blow it away, if you have time for that.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, awitney@sgul.ac.uk
Subject: Re: pg_dump error
In-Reply-To: <27244.1126104864@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox