Re: Database is in recovery mode. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Database is in recovery mode.
Date
Msg-id 9415.1322664043@sss.pgh.pa.us
Whole thread Raw
In response to Re: Database is in recovery mode.  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
Responses Re: Database is in recovery mode.
List pgsql-admin
Lukasz Brodziak <lukasz.brodziak@gmail.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

pgsql-admin by date:

Previous
From: "Nicholson, Brad (Toronto, ON, CA)"
Date:
Subject: Re: transaction error handling
Next
From: Lukasz Brodziak
Date:
Subject: Re: Database is in recovery mode.