Recovering / undoing transactions?

From: Ivan Voras <ivoras(at)freebsd(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Recovering / undoing transactions?
Date: 2007-11-07 12:50:43
Message-ID: fgsc5n$eqs$1@ger.gmane.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

About a month or so ago I read a blog entry or an article which seems to
have described a method, using dirty hackery with pg_resetxlog and
possibly other tools, to forcibly "undo" the database to a previous
state. The problem described was that some employee had executed a
"DELETE" or "UPDATE" without "WHERE" or something like it in autocommit
mode and the goal was to undo it.

I can't find the article now so can someone describe the technique here
or point to the article?

(I'm possibly misremembering important details about the article so the
correct answer to my question could be "no, it can't be done").

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reg Me Please 2007-11-07 12:54:36 Re: Postgresql simple query performance question
Previous Message SHARMILA JOTHIRAJAH 2007-11-07 12:47:26 Re: Postgresql simple query performance question