From: Tom Lane <tgl@sss.pgh.pa.us>
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database is in recovery mode.
Date: Wed, 30 Nov 2011 09:40:43 -0500
Message-ID: <9415.1322664043@sss.pgh.pa.us> (raw)
In-Reply-To: <CAGWYGjUDeh_FHej4iZw8hZHrrJVLryfr1Ahh4ByvdHht0cveww@mail.gmail.com>
References: <CAGWYGjWPiffET_K6QVXjjQO_jRQiUEU+BSZr1hurrh1Obv8wyQ@mail.gmail.com>
<CAOR=d=2UWeZt5ZnQaUQj2sXip2iTSZ2sx5ZEnNmh55pBiaXPww@mail.gmail.com>
<CAGWYGjUDeh_FHej4iZw8hZHrrJVLryfr1Ahh4ByvdHht0cveww@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, lukasz.brodziak@gmail.com, scott.marlowe@gmail.com
Subject: Re: Database is in recovery mode.
In-Reply-To: <9415.1322664043@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox