Re: Database corruption

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: George Woodring <george(dot)woodring(at)iglass(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database corruption
Date: 2010-08-30 16:45:41
Message-ID: 1283186652-sup-146@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2010-08-30 16:55:55 Running variable commands from psql
Previous Message Tom Lane 2010-08-30 16:08:38 Re: Question on trigger data visibility