Re: How to restore database to previous state

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to restore database to previous state
Дата
Msg-id CAKFQuwYUUJi=vKTPW+Zz4dJB6Ck0mP-kixoGK_j2iyMNtwkoyQ@mail.gmail.com
обсуждение исходный текст
Ответ на How to restore database to previous state  ("Andrus" <kobruleht2@hot.ee>)
Список pgsql-general
Дерево обсуждения
On Sun, May 10, 2020 at 2:43 PM Andrus <kobruleht2@hot.ee> wrote:
Is there simpler solution, e.q reverse playback of wal segments starting from current data directory contents.

There is no "unwind" or "undo" capability in PostgreSQL.  You need to separately get the database state to a point sometime before the target time and then restore until you attain the target time.

David J.

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

Предыдущее
От: "Ahmed, Nawaz (Fuji Xerox Australia)"
Дата:
Сообщение: RE: How to restore database to previous state
Следующее
От: Dennis Ryan
Дата:
Сообщение: Hash partitioning, what function is used to compute the hash?