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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2008-12-19 01:22:46 | Re: BUG #4559: performance issue |
Previous Message | raghavendra | 2008-12-18 10:17:06 | BUG #4588: post gres installation problem |