Re: lost data, possible playback? - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: lost data, possible playback?
Date
Msg-id dcc563d10712060841r29fe6addw65368349b152d9a7@mail.gmail.com
Whole thread Raw
In response to lost data, possible playback?  (Palle Girgensohn <girgen@pingpong.net>)
Responses Re: lost data, possible playback?  (Palle Girgensohn <girgen@pingpong.net>)
List pgsql-admin
On Dec 6, 2007 10:24 AM, Palle Girgensohn <girgen@pingpong.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.

pgsql-admin by date:

Previous
From: Palle Girgensohn
Date:
Subject: lost data, possible playback?
Next
From: Palle Girgensohn
Date:
Subject: Re: lost data, possible playback?