Chris Purcell wrote:
> On running pg_dump, I am consistently getting the following errors:
> pg_dump: ERROR: unexpected chunk number 2 (expected 0) for toast value
> pg_dump: SQL command to dump the contents of table "pagecache" failed:
> PQendcopy() failed.
> pg_dump: Error message from server: ERROR: unexpected chunk number 2
> (expected 0) for toast value 223327
> pg_dump: The command was: COPY meatballwiki.pagecache (page,
> lastmodified, response) TO stdout;
> I am running psql 8.1.4. The disk storing the database was recently
> corrupted, and we restored from an old image; I appreciate this is
> likely to have triggered the error. What I'm interested in is how to fix
"old image" - does that refer to something like an filesystem level
backup or the restoration of a former pg_dump generated backup ?
The former is generally NOT save (except if you followed the
PITR-advises in the docs or similiar) with a running postmaster ...
In response to
pgsql-bugs by date
|Next:||From: Chris Purcell||Date: 2006-09-12 11:02:40|
|Subject: Re: Unexpected chunk number|
|Previous:||From: Chris Purcell||Date: 2006-09-12 10:43:48|
|Subject: Unexpected chunk number|