Re: Database is in recovery mode.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Database is in recovery mode.
Date: 2011-11-30 14:40:43
Message-ID: 9415.1322664043@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-admin

Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> writes:
> I have isolated the corrupted row of data and isolated column which
> constains bad data. Unfortunately I can't do anything with the row. I have
> an older backup of the db which contains correct row. Is there a way I can
> restore only the given row or replace it in the file ( I also located the
> row on the page).

You haven't shown us exactly how it's failing, but depending on what
sort of corruption this is, you might be able to delete the damaged row
with
DELETE FROM table WHERE ctid = '...';

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lukasz Brodziak 2011-11-30 14:56:42 Re: Database is in recovery mode.
Previous Message Nicholson, Brad (Toronto, ON, CA) 2011-11-30 13:19:40 Re: transaction error handling