Re: lost data, possible playback?

[Palle Girgensohn <girgen(at)pingpong(dot)net>]

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