Re: Database corruption - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Database corruption
Date
Msg-id 1283186652-sup-146@alvh.no-ip.org
Whole thread Raw
In response to Database corruption  (George Woodring <george.woodring@iglass.net>)
List pgsql-general
Excerpts from George Woodring's message of lun ago 30 08:17:56 -0400 2010:
> I am running 8.3.3 currently on this box.
> Last week we had a database corruption issue that started as:
>
> Aug 24 07:15:19 iprobe028 postgres[20034]: [3-1] ERROR:  could not read
> block 0 of relation 1663/16554/7463400: read only 0 of 8192 bytes
> Aug 24 07:15:49 iprobe028 postgres[27663]: [3-1] ERROR:  could not read
> block 0 of relation 1663/16554/7463400: read only 0 of 8192 bytes

Please upgrade to 8.3.11 and let us know if it still happens.

--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question on trigger data visibility
Next
From: Bruce Momjian
Date:
Subject: Running variable commands from psql