Thread: Page header error on PGSQL 7.4.5
We have PostgreSQL v. 7.4.5 and main application
working with PGSQL via libpq.
Linux kernel 2.6.17.14
working with PGSQL via libpq.
Linux kernel 2.6.17.14
We encounter page header error occasional occurence in
different tables, including system pg_xxx.
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.
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.
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 :
of PostgreSQL, since the page header error also appeared under its version 8.3.1
with OS FreeBSD 7.0 :
Thank You!
âÏÇÄÁÎÏ× ÷. 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