invalid page header - Mailing list pgsql-admin

From Hornyak Laszlo
Subject invalid page header
Date
Msg-id Pine.LNX.4.21.0309252056430.5789-100000@tiger.tigrasoft.hu
Whole thread Raw
Responses Re: invalid page header  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi folks!

I have a problem again, now with PostgreSQL 7.3.4. One of my 1.8 million
rows tables have damaged, it operated all the day and now it is off, we
don`t know the reason. When we try to dump or select from it, it says
'Invalid page header in block 12345 in prep'.

Does anybody know how to make our table healthy again?
I have read oin the manual about pg_resetxlog, it says it may fix the
problem, but I should use it only as last solution. What is the risk of
using it? May it damage other tables?

Thanks in advance,
Laszlo Hornyak


pgsql-admin by date:

Previous
From: "Donald Fraser"
Date:
Subject: Re: Case Insensitive comparison
Next
From: Raj Mathur
Date:
Subject: Postgresql going to sleep?