fous velkej <honza...@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-gene...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
