Re: corruption since 7.4.13 update ? - Mailing list pgsql-admin

From Tom Lane
Subject Re: corruption since 7.4.13 update ?
Date
Msg-id 23854.1152837610@sss.pgh.pa.us
Whole thread Raw
In response to corruption since 7.4.13 update ?  (FM <dist-list@LEXUM.UMontreal.CA>)
List pgsql-admin
FM <dist-list@LEXUM.UMontreal.CA> writes:
> I'e got a very strange (scary) problem.

> ERROR:  could not read block 81235 of relation "pg_largeobject":
> Input/output error

This one is very strongly indicative of a disk hardware problem.
The others look like they could be consequences of catalog corruption
ensuing from a flaky disk.

If I were you I'd run some hardware diagnostics.  Also see if you can
pg_dump ...

            regards, tom lane

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Determining object name from filenode
Next
From: "Benjamin Krajmalnik"
Date:
Subject: Table size growing for no reason