Re: Database is in recovery mode.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Database is in recovery mode.
Дата
Msg-id 9415.1322664043@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Database is in recovery mode.  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
Ответы Re: Database is in recovery mode.
Список 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 по дате отправления:

Предыдущее
От: "Nicholson, Brad (Toronto, ON, CA)"
Дата:
Сообщение: Re: transaction error handling
Следующее
От: Lukasz Brodziak
Дата:
Сообщение: Re: Database is in recovery mode.