Search Postgresql Archives

Re: invalid page header

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

Markus Schiltknecht wrote:
I've done that (zeroing out the pg_toast table page) and hope
> the running pg_dump goes through fine.

Unfortunately, pg_dump didn't go through. I already did some REINDEXing and VACUUMing. Vacuum fixed something (sorry, don't I recall the message), but SELECTing from the table still fails, as some fields of course reference now deleted toast data:

ERROR:  missing chunk number 0 for toast value 479667

Is there any way to find this toast value 479667? Something like the following query:

SELECT id FROM my_corrupt_table
    WHERE pg_is_toasted('column')
        AND pg_toasted_value('column') == 479667;


Again, I'm fine loosing the data in the toasted fields in question. But I'd rather like to save the remaining data. I've already tried UPDATing a field I've found manually (by trial and error). That helped and I can now select that row again (having lost only the field's content).

Is there some sort of error recovery tool? Or should VACUUM fix such things on special request?

Regards

Markus

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux