| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | Michael Harris <michael(dot)harris(at)ericsson(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386 |
| Date: | 2011-02-28 04:24:47 |
| Message-ID: | DD13FAC4-5083-4E75-A93E-D5CD4F168F12@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 integrity of 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, only after restoring from the base backup + PITR.
Did you verify base backup (Restoring without PITR) ?
Thanks & Regards,
Vibhor Kumar
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Harris | 2011-02-28 04:43:55 | Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386 |
| Previous Message | Michael Harris | 2011-02-28 04:16:41 | Re: ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386 |