How to undo an update to a table?

From: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: How to undo an update to a table?
Date: 2014-04-22 20:08:23
Message-ID: 27F6554ED189174ABAA2EDB71E1350951AE5A049@XCH-PHX-202.sw.nos.boeing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

I updated certain rows of a table and made a mistake. Is there any way that I can roll back to the "previous" state of a table? We do nightly incremental backups and weekly full backups.

I'm running on Postgres 8.4.11.

Mary

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jorge Torralba 2014-04-22 20:23:15 Re: How to undo an update to a table?
Previous Message Simon Riggs 2014-04-22 16:07:12 Re: How does the WAL work? Need to recovery the database to a specific point of time