From: Andreas Schmitz <mailinglist@longimanus.net>
To: Johann Spies <jspies@sun.ac.za>
To: pgsql-admin@postgresql.org
Subject: Re: Corrupted database - how to recover
Date: Thu, 27 May 2010 09:54:00 +0200
Message-ID: <4BFE2518.3050601@longimanus.net> (raw)
In-Reply-To: <20100527073404.GA32267@sun.ac.za>
References: <20100527073404.GA32267@sun.ac.za>
hi johann,
maybe you should consider using point in time recovery (pitr) if the
database is mission critical.
http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html
regards
andreas
Johann Spies wrote:
> After two disks on our raid-5 system failed causing a filesystem
> failure.
>
> We could get one online again and the filesystem is at present usable
> but I cannot start postgresql at the moment:
>
> $ /usr/lib/postgresql/8.3/bin/postgres --single -D /etc/postgresql/8.3/main/
> 2010-05-27 09:22:48 SAST FATAL: could not stat directory "base/16400": Structure needs cleaning
> 2010-05-27 09:22:48 SAST CONTEXT: xlog redo insert: rel 1663/16400/16438; tid 10960/41
>
> in 'base' I see
>
> drwx------ 10 postgres postgres 102 2010-04-22 15:09 .
> drwx------ 10 postgres postgres 4096 2010-05-27 09:29 ..
> drwx------ 2 postgres postgres 4096 2010-05-20 02:11 1
> drwx------ 2 postgres postgres 4096 2010-04-22 15:07 11510
> ?????????? ? ? ? ? ? 16388
> drwx------ 2 postgres postgres 4096 2010-05-20 02:11 16389
> drwx------ 2 postgres postgres 4096 2010-05-20 02:11 16390
> drwx------ 2 postgres postgres 4096 2010-05-20 02:11 16391
> ?????????? ? ? ? ? ? 16400
>
> I can just move the data-directory, do an initdb and use an older dump
> to repair the database as it was some time ago. Fortunately the data is
> not mission critical. But what if it was.
>
> How do I recover from a situation like this?
>
> Regards
> Johann
>
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: mailinglist@longimanus.net, jspies@sun.ac.za
Subject: Re: Corrupted database - how to recover
In-Reply-To: <4BFE2518.3050601@longimanus.net>
* 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