Богданов В. 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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
