Re: lost data, possible playback?

["Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>]

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.