From: | Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com> |
---|---|
To: | "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How to undo an update to a table? |
Date: | 2014-04-22 20:23:15 |
Message-ID: | CACut7uSdekkjSs0UEOf8KU=chb2bdi5--21GYh=nKb8+se+b2w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Too late for a rollback ?
If you are doing incremental the only thing I can think of now is restoring
your cluster to a different environment to a point in time, then copy table
content and repopulate or update the table in question. Sounds like a lot
of work but doable.
On Tue, Apr 22, 2014 at 1:08 PM, Wang, Mary Y <mary(dot)y(dot)wang(at)boeing(dot)com>wrote:
> 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
>
--
Thanks,
Jorge Torralba
----------------------------
Note: This communication may contain privileged or other confidential
information. If you are not the intended recipient, please do not print,
copy, retransmit, disseminate or otherwise use the information. Please
indicate to the sender that you have received this email in error and
delete the copy you received. Thank You.
From | Date | Subject | |
---|---|---|---|
Next Message | Payal Singh | 2014-04-22 20:30:08 | Re: How to undo an update to a table? |
Previous Message | Wang, Mary Y | 2014-04-22 20:08:23 | How to undo an update to a table? |