From: | "Ruslan A(dot) Bondar" <fsat(at)list(dot)ru> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | How to deal with corrupted database? |
Date: | 2011-11-09 11:02:25 |
Message-ID: | 20111109150225.076c2f38@list.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello all.
This is a first time I receive such an issue.
My database was corrupted some way.
When I'm trying to access the database via psql I receive:
root(at)udb:/etc/bacula# psql -U bacula
psql: FATAL: could not read block 0 in file "base/16387/86057840": read only 0 of 8192 bytes
So I want to drop it, and recover from backup. But when I'm trying to drop the database I see:
postgres=# drop database bacula;
ERROR: could not access status of transaction 15892843
DETAIL: Could not open file "pg_subtrans/00F2": No such file or directory.
Is there any way to recover the database to working state, or drop it?
OS: Linux Debian Sid
postgres version: 9.0.4
uname: Linux udb 2.6.32-5-xen-686 #1 SMP Tue Oct 19 17:09:04 UTC 2010 i686 GNU/Linux
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Burbello | 2011-11-09 11:28:37 | Exp/Imp data with blobs |
Previous Message | Jesper Krogh | 2011-11-08 19:24:39 | Untraditional point in time recovery. |