Re: Vacuumdb error

"Bhella Paramjeet-PFCW67" <PBhella@Motorola.com> writes:
> We have our production postgres 8.0.10 database running on linux x86_64
> machine. Recently we have started getting an error from one of our
> database while running vacuumdb. We are not getting this error during
> backups just only during vacuuming of a database. Can anyone please help
> us figure out why we are getting this error and how we can get rid of
> it. Any help will be appreciated.

> Here is the error:
> tst_021 ERROR:  invalid page header in block 8 of relation
> "securityevent_pkey"

Well, since it's just an index, you should be able to fix it by
reindexing.  But I'd worry a bit about what caused the corruption.
8.0.10 is not exactly current --- you should update to 8.0.latest.
And running some memory and disk diagnostics might not be wasted
effort.

            regards, tom lane