Re: "could not read block 0... " error followed by "database does not exist"

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Janet S Jacobsen <JSJacobsen(at)lbl(dot)gov>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: "could not read block 0... " error followed by "database does not exist"
Date: 2010-02-13 03:20:06
Message-ID: dcc563d11002121920g5ae51261qc7d85bc08bb31b38@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 12, 2010 at 7:11 PM, Janet S Jacobsen <JSJacobsen(at)lbl(dot)gov> wrote:
> Hi.  I am running Postgres 8.2.7 on a Linux system for over
> a year now with no problems.
>
> Today one of the database users reported the following error:
>
>   psql: FATAL:  could not read block 0 of relation 1664/0/1262: read
>   only 0 of 8192 bytes

Sounds like a bad sector on your hard drive. Got any recent backups?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Janet S Jacobsen 2010-02-13 06:07:46 Re: "could not read block 0... " error followed by "database does not exist"
Previous Message Tom Lane 2010-02-13 02:57:56 Re: "could not read block 0... " error followed by "database does not exist"