Re: Page header error on PGSQL 7.4.5

âÏÇÄÁÎÏ× ÷. 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