Skip site navigation (1) Skip section navigation (2)

invalid page header

From: Hornyak Laszlo <kocka(at)tigrasoft(dot)hu>
To: pgsql-admin(at)postgresql(dot)org
Subject: invalid page header
Date: 2003-09-25 19:01:26
Message-ID: Pine.LNX.4.21.0309252056430.5789-100000@tiger.tigrasoft.hu (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-admin by date

Next:From: Raj MathurDate: 2003-09-25 19:19:30
Subject: Postgresql going to sleep?
Previous:From: Donald FraserDate: 2003-09-25 18:33:30
Subject: Re: Case Insensitive comparison

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group