From: | Payal Singh <payal(at)omniti(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:30:08 |
Message-ID: | CANUg7LDutTg8g8WyfNi2FCTXeZcYi4JdxZV3xu0bqRMSNm-f5g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
what kind of backups are you taking? If you have dump backups, you can
restore the single table to a different instance of with a different table
name, and then switch the new and old tables. Although, you would be lucky
if this solution works for you, since the table might have dependencies
which might make it difficult to do this.
Another thing you can do to ensure faster recovery is :
1. restore the backup to a new instance. This should be from a backup
before the update
2. Get the changed rows
3. update these rows in the actual table.
Payal Singh,
Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253
On Tue, Apr 22, 2014 at 4: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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Yue Wang | 2014-04-25 07:14:57 | about the copy command |
Previous Message | Jorge Torralba | 2014-04-22 20:23:15 | Re: How to undo an update to a table? |