How to undo an update to a table?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: How to undo an update to a table?
From: "Wang, Mary Y" <mary.y.wang@xxxxxxxxxx>
Date: Tue, 22 Apr 2014 20:08:23 +0000
Accept-language: en-US
Sender: pgsql-admin-owner@xxxxxxxxxxxxxx
Thread-index: Ac9eZp18TbnOqg6PSISZYglqu6SSQg==
Thread-topic: How to undo an update to a table?

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

Follow-Ups:
- Re: How to undo an update to a table?
  - From: Payal Singh
- Re: How to undo an update to a table?
  - From: Jorge Torralba

Prev by Date: Re: How does the WAL work? Need to recovery the database to a specific point of time
Next by Date: Re: How to undo an update to a table?
Previous by thread: How does the WAL work? Need to recovery the database to a specific point of time
Next by thread: Re: How to undo an update to a table?
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux