Богданов В. wrote:
> We have PostgreSQL v. 7.4.5 and main application
> working with PGSQL via libpq.
> Linux kernel 188.8.131.52
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?
In response to
pgsql-bugs by date
|Next:||From: Craig Ringer||Date: 2008-12-19 01:22:46|
|Subject: Re: BUG #4559: performance issue|
|Previous:||From: raghavendra||Date: 2008-12-18 10:17:06|
|Subject: BUG #4588: post gres installation problem|