Re: invalid page header

"Dumping and reloading the table that owns this toast table would be a safer route; it would at
least make it real clear what damage you'd suffered."

Is this b/c the damaged pages would be zero'd out?   I tried searching the docs, but it seems the search daemon is
down.

Thanks
Michael



Tom Lane wrote:

>Michael Guerin <guerin@rentec.com> writes:
>
>
>>INFO:  vacuuming "pg_toast.pg_toast_17242"
>>ERROR:  invalid page header in block 2003917 of relation "pg_toast_17242"
>>
>>
>
>
>
>>Is there a way to fix this error, or do I need to rebuild the table?
>>
>>
>
>zero_damaged_pages would get you past that error, but I'd be worrying
>about what data you've lost or are going to lose.  Dumping and reloading
>the table that owns this toast table would be a safer route; it would at
>least make it real clear what damage you'd suffered.
>
>            regards, tom lane
>
>