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

From: Janet S Jacobsen <JSJacobsen(at)lbl(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Cc: jsjacobsen(at)lbl(dot)gov
Subject: "could not read block 0... " error followed by "database does not exist"
Date: 2010-02-13 02:11:09
Message-ID: f259b9bd4a6d.4b7599bd@lbl.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

I tried stopping and restarting the Postgres server for the database.
>From the logfile:

LOG: received smart shutdown request
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2010-02-12 17:15:37 PST
LOG: autovacuum launcher started
LOG: database system is ready to accept connections

But when I try to connect to the database, I get the error message:

FATAL: database "subptf" does not exist

I tried stopping/restarting the database several times. I also
killed all user connections to the database.

How do I fix this problem?

Thanks,
Janet

Responses

Browse pgsql-general by date

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