From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
Cc: pgsql-admin@postgresql.org, "Subbiah Stalin-XCGF84" <SSubbiah@Motorola.com>
Subject: Re: Vacuumdb error
Date: Thu, 17 Apr 2008 20:18:05 -0400
Message-ID: <2242.1208477885@sss.pgh.pa.us> (raw)
In-Reply-To: <C84662912D280D4AB5C50100A100F0C5034A6171@ct11exm61.ds.mot.com>
References: <C84662912D280D4AB5C50100A100F0C5034A6171@ct11exm61.ds.mot.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, PBhella@Motorola.com, SSubbiah@Motorola.com
Subject: Re: Vacuumdb error
In-Reply-To: <2242.1208477885@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox