Re: Invalid page header in block xxxx

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Carmen Wai" <wai_carmen(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Invalid page header in block xxxx
Date: 2003-11-23 18:16:48
Message-ID: 28285.1069611408@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Carmen Wai" <wai_carmen(at)hotmail(dot)com> writes:
> I am a new user of postgresql. I am using postgresql 7.3.4 and I had
> inserted about 1.7 million records to a table. When I vacuum / select * from
> table, it gets a error message of : Invalid page header in block xxx of
> TableA. I check that I still can insert records to the table. But I am not
> able to get part of the data (as I try to copy all records to text file,
> only around 1.6 million records are copied.)

It sounds to me like you have unreliable disk hardware --- I'd suggest
running badblocks or some other disk-tester program to look for problems.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tino Wildenhain 2003-11-23 18:19:05 Re: retrieve statement from catalogs
Previous Message Tom Lane 2003-11-23 18:11:09 Re: PGSQL on shared hosting