Re: Database is in recovery mode.

Hello,

Thank You for the reply. I managed to delete the row the way below:
1. Using EMS Manager for PostgreSQL I selected all the rows except the
corrupted one.
2. Extracted the data to INSERT script
3. SET zero_damaged_pages TO true; VACUUM FULL table;
4. DROP/CREATE
5. INSERT script without the corrupted row
6. INSERT script for the missing row created with EMS from the las
uncorrupted data folder

Everything went as predicted and the table is ok now.

2011/11/30 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> 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
>

--
Łukasz Brodziak
"Do you bury me when I'm gone
Do you teach me while I'm here
Just as soon I belong
Then it's time I disappear"