Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386 - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386
Date
Msg-id DD13FAC4-5083-4E75-A93E-D5CD4F168F12@enterprisedb.com
Whole thread Raw
In response to Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386  (Michael Harris <michael.harris@ericsson.com>)
Responses Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386
List pgsql-general
On Feb 28, 2011, at 9:46 AM, Michael Harris wrote:

> The main reason we have not gone down that path that after getting this error we do not have any confidence in the
integrityof the rest of the database after performing the restore - maybe there are many more tables with corruption in
them.
May be or may not be.

Did you find anything suspicious in pg_log?
Please share recovery.conf information.


> We are mainly concerned that our backups are valid. The fault does not seem to be present on the original database,
onlyafter restoring from the base backup + PITR. 


Did you verify base backup (Restoring without PITR) ?

Thanks & Regards,
Vibhor Kumar
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com


pgsql-general by date:

Previous
From: Michael Harris
Date:
Subject: Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386
Next
From: Michael Harris
Date:
Subject: Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386