Adam Witney <[EMAIL PROTECTED]> writes:
> bugasbase2=# SELECT count(*) from mba_data_base;
> ERROR: invalid page header in block 597621 of relation "mba_data_base"
Sounds like a data corruption problem :-(. Do you want to pull out that
page and see what's in it? Something like
dd bs=8k skip=73333 count=1 if=relationfile | od -x
where you need to use oid2name or something similar to determine which
file contains that relation, and then append ".4" because block 597621
would be in the fifth segment of the file. (I got 73333 from
"select 597621 % 131072")
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
