Re: lost data, possible playback?

--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?

/Palle