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,
pgsql-admin by date
|Next:||From: Raj Mathur||Date: 2003-09-25 19:19:30|
|Subject: Postgresql going to sleep?|
|Previous:||From: Donald Fraser||Date: 2003-09-25 18:33:30|
|Subject: Re: Case Insensitive comparison|