ERROR: invalid page header in block 502758 of relation base/16388/16403

From: fous velkej <honza801(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: ERROR: invalid page header in block 502758 of relation base/16388/16403
Date: 2009-09-14 14:07:07
Message-ID: 27cffc0909140707u4e7832e4o795ff9c6c6268a13@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

hi,

i got following error while selecting from my db

ERROR: invalid page header in block 502758 of relation base/16388/16403

i've found some solution in this thread
http://www.mail-archive.com/pgsql-general(at)postgresql(dot)org/msg101644.html

but my problem is, that there are multiple files with similar name in
the base/16388 directory.
16403 (1Gb)
16403.1 (1Gb)
16403.2 (1Gb)
16403.3 (almost 1 Gb)

so the question is, where can i find the right 502758 position (i
assume that this is the number of 8k block position).
each file with size 1Gb has 131072 of 8k blocks.

thanx for help
fous

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message fous velkej 2009-09-14 14:10:11 Re: ERROR: invalid page header in block 502758 of relation base/16388/16403
Previous Message Robert Haas 2009-09-14 13:34:11 Re: BUG #5046: java developer