From: Ruslan A. Bondar <fsat@list.ru>
To: pgsql-admin@postgresql.org
Subject: How to deal with corrupted database?
Date: Wed, 9 Nov 2011 15:02:25 +0400
Message-ID: <20111109150225.076c2f38@list.ru> (raw)
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@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: fsat@list.ru
Subject: Re: How to deal with corrupted database?
In-Reply-To: <20111109150225.076c2f38@list.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox