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
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? |