Invalid page header in block...

From: Konstantinos Agouros <elwood(at)agouros(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Invalid page header in block...
Date: 2004-04-04 15:28:20
Message-ID: 20040404152820.GA16249@rumba.agouros.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a machine that is currently a bit unstable. No I got a:
sysad=# select * from attacks where start < '1.1.2000';
ERROR: Invalid page header in block 3618 of attacks

From googeling I saw that this should be solvable if I can delete the bad rows
or find the bad datafile. Anybody has a tip on how to do that? Because I could
not find the how in detail.

The whole thing is 7.3.6 on Gentoo Linux.

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood(at)agouros(dot)de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not survive the forming of the cosmos." B'Elana Torres

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2004-04-04 17:27:44 Re: thread_test.c problems
Previous Message wespvp 2004-04-04 09:03:05 Re: thread_test.c problems