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

fous velkej <honza801@gmail.com> writes:
> 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@postgresql.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.

Right, so it would be in the .3 file at block number 109542.

regression=# select 502758 / 131072;
 ?column?
----------
        3
(1 row)

regression=# select 502758 % 131072;
 ?column?
----------
   109542
(1 row)


            regards, tom lane