"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
>
>