Postgres Pro
Downloads
Home   >   mailing lists

How to undo an update to a table? - Mailing list pgsql-admin

From Wang, Mary Y
Subject How to undo an update to a table?
Date
Msg-id 27F6554ED189174ABAA2EDB71E1350951AE5A049@XCH-PHX-202.sw.nos.boeing.com
Whole thread Raw
Responses Re: How to undo an update to a table?  (Jorge Torralba <jorge.torralba@gmail.com>)
Re: How to undo an update to a table?  (Payal Singh <payal@omniti.com>)
List pgsql-admin
Tree view

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

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: How does the WAL work? Need to recovery the database to a specific point of time
Next
From: Jorge Torralba
Date:
Subject: Re: How to undo an update to a table?