Re: lost data, possible playback?

--On torsdag, december 06, 2007 17.45.57 +0100 Palle Girgensohn
<girgen(at)pingpong(dot)net> wrote:

>
>
> --On torsdag, december 06, 2007 10.41.40 -0600 Scott Marlowe
> <scott(dot)marlowe(at)gmail(dot)com> wrote:
>
>> On Dec 6, 2007 10:24 AM, Palle Girgensohn <girgen(at)pingpong(dot)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.
>
> So, I *must* have an image of the entire database, and I *must* have all
> WAL files since the image snapshot was taken?

Is the real reason for the negative answer that there is a "hole" in the
pg_xlogs from 3 am - 9 am?

Palle