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

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 (view raw, whole thread or download thread 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

pgsql-admin by date

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

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