From: Craig Ringer <ringerc@ringerc.id.au>
To: Ruslan A. Bondar <fsat@list.ru>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to deal with corrupted database?
Date: Wed, 09 Nov 2011 21:04:47 +0800
Message-ID: <4EBA7A6F.50602@ringerc.id.au> (raw)
In-Reply-To: <20111109150225.076c2f38@list.ru>
References: <20111109150225.076c2f38@list.ru>
On 11/09/2011 07:02 PM, Ruslan A. Bondar wrote:
> Hello all.
>
> This is a first time I receive such an issue.
> My database was corrupted some way.
Before you do ANYTHING else, make a copy of your database somewhere
safe. See:
http://wiki.postgresql.org/wiki/Corruption> 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?
>
*ONLY* once you've made a full backup copy, you may be able to set
zero_damaged_pages to get a usable dump.
Do you know what caused this? The missing files suggest it was probably
file system corruption - was there a disk failure? fsck run with errors?
Unexpected reboot on a RAID controller with a dead backup battery?
--
Craig Ringer
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: ringerc@ringerc.id.au, fsat@list.ru
Subject: Re: How to deal with corrupted database?
In-Reply-To: <4EBA7A6F.50602@ringerc.id.au>
* 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