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

Re: Page header error on PGSQL 7.4.5

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: "Богданов В(dot)" <valeriy(at)yandex(dot)ru>
Cc: PGSQL_bugs forum <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Page header error on PGSQL 7.4.5
Date: 2008-12-18 10:33:25
Message-ID: 494A26F5.7020504@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Богданов В. wrote:
> We have PostgreSQL v. 7.4.5 and main application
> working with PGSQL via libpq. 
> Linux kernel 2.6.17.14

7.4.5 is very old. The latest minor version of the 7.4 series is 7.4.23. 
There has been a lot of bug fixes in between; you really should upgrade.

> We encounter page header error occasional occurence in 
> different tables, including system pg_xxx.
> 
> Database is restored transactionally using restore.sql commands:
> 
> drop table ..., create table ... , copy ... from ...
> 
> from night dump automatically and we have no problems.
> 
> Equipment: processor ST sh4-7100, RAM 128 MB.
> 
> Disk partition size where the PostgreSQL is installed, is of 100 GB.
> 
> Cluster size is about 90 MB.
> 
> We have about a hundred of computer with similar configuration.
> 
> On most of them the error doesn't appear for months, even when the equipment 
> is rather carelessly operated including power interruption without 
> due termination of PostgreSQL work.
> 
> We have installed PostgreSQL 8.2.5 on several test devices, and the error didn't appear,
> but the test period was rather short. 
> 
> After all this we are considering the necessity of moving to the latest version 
> of PostgreSQL, since the page header error also appeared under its version 8.3.1 
> with OS FreeBSD 7.0  :

That sounds very random. I suspect bad hardware, bad RAM perhaps. On how 
many computers does the error occur?

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

pgsql-bugs by date

Next:From: Craig RingerDate: 2008-12-19 01:22:46
Subject: Re: BUG #4559: performance issue
Previous:From: raghavendraDate: 2008-12-18 10:17:06
Subject: BUG #4588: post gres installation problem

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