Grokbase
x

Re: lost data, possible playback?

View PostFlat  Thread  Threaded | < Prev - Next >
Palle Girgensohn Re: lost data, possible playback?
| +1 vote
[ Profile | Reply to group ] [ Flat  Thread  Threaded ]
--On torsdag, december 06, 2007 12.22.45 -0500 Tom Lane <tgl@sss.pgh.pa.us>
wrote:

> Palle Girgensohn <girgen@pingpong.net> writes:
>> Is the real reason for the negative answer that there is a "hole" in the
>> pg_xlogs from 3 am - 9 am?
>
> That's half of it. The other half is that what you have from 3am is a
> pg_dump, not a filesystem-level snapshot of the database, and you'd need
> the latter to be able to replay the WAL log against.

OK, my assumptions where correct. Thanks.

/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 | < Prev - Next >