Re: lost data, possible playback?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: lost data, possible playback?
Дата
Msg-id dcc563d10712060841r29fe6addw65368349b152d9a7@mail.gmail.com
обсуждение исходный текст
Ответ на lost data, possible playback?  (Palle Girgensohn <girgen@pingpong.net>)
Ответы Re: lost data, possible playback?  (Palle Girgensohn <girgen@pingpong.net>)
Список pgsql-admin
On Dec 6, 2007 10:24 AM, Palle Girgensohn <girgen@pingpong.net> wrote:
> Hi!
>
> A user accidentally deleted some results (i.e. tuples in a postgresql
> database) created this morning.
>
> I have pg_xlog from about 9 o'clock until now. I have a pg_dump from ab out
> 3 o'clock this morning.
>
> The results where created from about nine o'clock until noon, when the user
> accidentally removed the results.
>
> Would it be possible to replay the WAL logs and get the results from
> pg_xlog + the dump?

No.

> Or from a file system snapshot as of now (five pm) + pg_xlog?

No.

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

Предыдущее
От: Palle Girgensohn
Дата:
Сообщение: lost data, possible playback?
Следующее
От: Palle Girgensohn
Дата:
Сообщение: Re: lost data, possible playback?