| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, "Subbiah Stalin-XCGF84" <SSubbiah(at)Motorola(dot)com> |
| Subject: | Re: Vacuumdb error |
| Date: | 2008-04-18 00:18:05 |
| Message-ID: | 2242.1208477885@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2008-04-18 01:13:15 | Re: checkcommands.conf templates for check_postgres.pl |
| Previous Message | Tom Lane | 2008-04-18 00:15:23 | Re: duplicate primary index in bayes db from SpamAssassin |