Skip site navigation (1) Skip section navigation (2)

Re: Database is in recovery mode.

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database is in recovery mode.
Date: 2011-11-29 04:51:07
Message-ID: CAOR=d=2UWeZt5ZnQaUQj2sXip2iTSZ2sx5ZEnNmh55pBiaXPww@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Nov 28, 2011 at 10:11 AM, Lukasz Brodziak
<lukasz(dot)brodziak(at)gmail(dot)com> wrote:
> Hello,
> I have a problem with client's database. When I log into application and
> work on the data everything seems fine, but when I try to dumpd the database
> connection closes. I have located the faulty table and when I try to cluster
> it I get FATAL: database is in recovery mode. It seems that there are some
> corrupted rows in the table but I can't find the way to repai the table and
> therefore whole DB.
> PG is in the version 8.2 (in 2 weeks we are migrating to 9.0 and we are

After taking a file system level backup as suggested by Craig, first
try updating to the latest point release of 8.2.  There's literally
years differences / bug fixes between 8.2.0 and 8.2.22 which was the
last release.  It might be that simply updating to 8.2.22 will fix
your problems.

In response to

Responses

pgsql-admin by date

Next:From: senthilnathanDate: 2011-11-29 12:08:32
Subject: Re: streaming replication
Previous:From: Craig RingerDate: 2011-11-29 02:48:42
Subject: Re: Repeatable crash in pg_dump (with -d2 info)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group