pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Geoffrey <esoteric@3times25.net>
To: pgsql-admin@postgresql.org
To: pgsql-general@postgresql.org
Subject: Re: vacuum fails with 'invalid page header' message
Date: Fri, 05 Jan 2007 17:19:20 -0500
Message-ID: <459ECEE8.5030806@3times25.net> (raw)
In-Reply-To: <459EC34E.3070304@3times25.net>
References: <459EC34E.3070304@3times25.net>

Geoffrey wrote:
> We had a vacuum fail recently with the following error:
> 
> invalid page header in block 846 of relation "move_pkey"
> 
> Anyone have an idea what could cause this problem and what we need to do 
>  to resolve it?
> 
> Running on Red Hat Enterprise 3, postgres 7.4.13

Regarding the issue above, is it possible that re-indexing the database 
could resolve the problem, since the error is related to an index. 
move_pkey is an index on field recid.

-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin



view thread (4+ messages)  latest in thread

Message-ID: <459ECEE8.5030806@3times25.net>
Permalink:  ../459ECEE8.5030806@3times25.net/
Also on:    postgresql.org/message-id/459ECEE8.5030806@3times25.net

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: esoteric@3times25.net, pgsql-general@postgresql.org
  Subject: Re: vacuum fails with 'invalid page header' message
  In-Reply-To: <459ECEE8.5030806@3times25.net>
  References: <459EC34E.3070304@3times25.net> <459ECEE8.5030806@3times25.net>

* 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