Postgres Pro
Downloads
Home   >   mailing lists

Re: "could not read block 0... " error followed by "database does not exist" - Mailing list pgsql-general

From Scott Marlowe
Subject Re: "could not read block 0... " error followed by "database does not exist"
Date
Msg-id dcc563d11002121920g5ae51261qc7d85bc08bb31b38@mail.gmail.com
Whole thread Raw
In response to "could not read block 0... " error followed by "database does not exist"  (Janet S Jacobsen <JSJacobsen@lbl.gov>)
List pgsql-general
Tree view 
On Fri, Feb 12, 2010 at 7:11 PM, Janet S Jacobsen <JSJacobsen@lbl.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?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: "could not read block 0... " error followed by "database does not exist"
Next
From: Janet Jacobsen
Date:
Subject: "could not read block 0... " error followed by "database does not exist"