Grokbase
x

lost data, possible playback?

View PostFlat  Thread  Threaded | Next >
Palle Girgensohn lost data, possible playback?
| +1 vote
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
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

Thread : lost data, possible playback?
1)
Palle Girgensohn Hi! A user accidentally deleted some results (i.e. tuples in a postgresql database) created this...
2)
Scott Marlowe No. No....
3)
Palle Girgensohn --On torsdag, december 06, 2007 17.45.57 +0100 Palle Girgensohn Is the real reason for the negative...
4)
Palle Girgensohn --On torsdag, december 06, 2007 12.22.45 -0500 Tom Lane <tgl@sss.pgh.pa.us> OK, my assumptions...
5)
Palle Girgensohn --On torsdag, december 06, 2007 10.41.40 -0600 Scott Marlowe So, I *must* have an image of the...
6)
Tom Lane That's half of it. The other half is that what you have from 3am is a pg_dump, not a...
7)
Scott Marlowe No, the problem is that you don't have a system image from before the problem occurred. You need a...
spacer
View PostFlat  Thread  Threaded | Next >