Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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



      

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group