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

From Palle Girgensohn
Subject Re: lost data, possible playback?
Date
Msg-id 944C667FD85B40CE6350DB41@rambutan.pingpong.net
Whole thread Raw
In response to Re: lost data, possible playback?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin

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


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: lost data, possible playback?
Next
From: "Scott Marlowe"
Date:
Subject: Re: lost data, possible playback?