Corruption on production system

From: "Eric B(dot) Ridge" <ebr(at)tcdi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Corruption on production system
Date: 2005-04-26 00:24:03
Message-ID: B20EC3D9-4856-46C7-9F7D-5FDFDA3BCA88@tcdi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We've got a PG 7.3.6 installation that just started receiving this
error:
2005-04-25 19:28:54 ERROR: Invalid page header in block 1110 of
the_table_name

We're also unable to dump that table using pg_dump. Postgres isn't
actually crashing, so I'm not sure how to get a backtrace out of it.

SELECT version():
PostgreSQL 7.3.6 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.3.2 20031218 (Gentoo Linux 3.3.2-r5, propolice-3.3-7)

(Don't get upset that it says Gentoo -- I built it myself from
official Postgres sources)

Is page header corruption a known issue with 7.3.6 and should I
upgrade to 7.3.9 at the same time that I'm restoring this table from
backup?

Any quick advice will be greatly appreciated!

thanks

eric

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-04-26 01:03:52 Re: question about about future 8.1 and IN, INOUT, and OUT parameters
Previous Message Rob Stone 2005-04-25 23:55:40 Re: Intuitive Software and Mario Brothers