pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Vacuumdb error
2+ messages / 2 participants
[nested] [flat]

* Vacuumdb error
@ 2008-04-17 23:21  Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Bhella Paramjeet-PFCW67 @ 2008-04-17 23:21 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Subbiah Stalin-XCGF84 <SSubbiah@Motorola.com>

Hi,

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"


Thanks
Paramjeet Bhella
 



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Vacuumdb error
@ 2008-04-18 00:18  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2008-04-18 00:18 UTC (permalink / raw)
  To: Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>; +Cc: pgsql-admin@postgresql.org, "Subbiah Stalin-XCGF84" <SSubbiah@Motorola.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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2008-04-18 00:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-17 23:21 Vacuumdb error Bhella Paramjeet-PFCW67 <PBhella@Motorola.com>
2008-04-18 00:18 ` Tom Lane <tgl@sss.pgh.pa.us>

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