ERROR: invalid page header in block 24555 of relation "logs_20080425"

From: val <valiouk(at)yahoo(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: ERROR: invalid page header in block 24555 of relation "logs_20080425"
Date: 2008-11-18 15:38:26
Message-ID: 180518.66454.qm@web25802.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am getting the above error. Can I do anything to fix this? I can get most of the data in the table but queries that go pass that block don't work. Is there a way to recover more of the data in the table?

I am running PostgreSQL 8.1.11 on Linux.

Thanks

Browse pgsql-admin by date

  From Date Subject
Next Message Arctic Toucan 2008-11-18 15:40:26 Is it safe to reset relfrozenxid without using vacuum?
Previous Message Sabin Coanda 2008-11-18 14:16:16 usability on output pane