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

From Palle Girgensohn
Subject lost data, possible playback?
Date
Msg-id 9FD29C9B828B9182011BDDF5@rambutan.pingpong.net
Whole thread Raw
Responses Re: lost data, possible playback?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-admin
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? Or from a file system snapshot as of now (five pm) +
pg_xlog?

Regards,
Palle


pgsql-admin by date:

Previous
From: "ebubekir temizkan"
Date:
Subject: I want to Collect information about postgresql
Next
From: "Scott Marlowe"
Date:
Subject: Re: lost data, possible playback?