Re: How to undo an update to a table?

Поиск
Список
Период
Сортировка
От Jorge Torralba
Тема Re: How to undo an update to a table?
Дата
Msg-id CACut7uSdekkjSs0UEOf8KU=chb2bdi5--21GYh=nKb8+se+b2w@mail.gmail.com
обсуждение исходный текст
Ответ на How to undo an update to a table?  ("Wang, Mary Y" <mary.y.wang@boeing.com>)
Список 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.y.wang@boeing.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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Wang, Mary Y"
Дата:
Сообщение: How to undo an update to a table?
Следующее
От: Payal Singh
Дата:
Сообщение: Re: How to undo an update to a table?