Extract transactions from wals ??

Поиск
Список
Период
Сортировка
От Marc Millas
Тема Extract transactions from wals ??
Дата
Msg-id CADX_1abgdEKNaMJxSykE6QJGs0HwrK1YU2ZSzZQv-CngiU_6bQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Extract transactions from wals ??
Список pgsql-general
Hi,

due to a set of bugs and wrong manip, an inappropriate update have been done into a production DB.
After that, quite a long set of valuables inserts and updates have been done and needs to be kept.
Obviously getting a backup and applying pitr will get us just before the offending update.
Now, we need to find a way of extracting, either from the ex prod db, or from the wals, the "good" transactions to be able to re-apply them.

This did already happen on a Prod  Oracle DB, and recovering was possible with a :
select * from table_name AS OF TIMESTAMP TO_TIMESTAMP('09052019 0900','MMDDYYYY HH24MI');
to get most things done after the problem.
As we are currently moving out of Oracle, we must prove to the business people that our new postgres env is fine.
So, ... any idea ?

thanks,


Marc MILLAS
Senior Architect
+33607850334

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Help with authentication on Debain/Ubuntu installation
Следующее
От: stan
Дата:
Сообщение: Re: Help with authentication on Debain/Ubuntu installation