lost data, possible playback?

Поиск
Список
Период
Сортировка
От Palle Girgensohn
Тема lost data, possible playback?
Дата
Msg-id 9FD29C9B828B9182011BDDF5@rambutan.pingpong.net
обсуждение исходный текст
Ответы Re: lost data, possible playback?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-admin
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? Or from a file system snapshot as of now (five pm) +
pg_xlog?

Regards,
Palle


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

Предыдущее
От: "ebubekir temizkan"
Дата:
Сообщение: I want to Collect information about postgresql
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: lost data, possible playback?