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

From: Janet Jacobsen <jacobsen(at)hpcrd(dot)lbl(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: "could not read block 0... " error followed by "database does not exist"
Date: 2010-02-13 02:00:14
Message-ID: 4B7607AE.8010201@hpcrd.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

Browse pgsql-general by date

  From Date Subject
Next Message Janet S Jacobsen 2010-02-13 02:11:09 "could not read block 0... " error followed by "database does not exist"
Previous Message Allan Kamau 2010-02-12 19:21:35 Re: Weeding out unused user created database objects, could I use pg_catalog?