Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: lost data, possible playback?
- From: Palle Girgensohn <girgen(at)pingpong(dot)net>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org, kudo(at)pingpong(dot)net
- Subject: Re: lost data, possible playback?
- Date: Thu, 06 Dec 2007 18:34:58 +0100
--On torsdag, december 06, 2007 12.22.45 -0500 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
Palle Girgensohn <girgen(at)pingpong(dot)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
- References:
- lost data, possible playback?
- From: Palle Girgensohn
- Re: lost data, possible playback?
- From: Scott Marlowe
- Re: lost data, possible playback?
- From: Palle Girgensohn
- Re: lost data, possible playback?
- From: Palle Girgensohn
- Re: lost data, possible playback?
- From: Tom Lane
- lost data, possible playback?
- Prev by Date: Re: lost data, possible playback?
- Next by Date: Re: lost data, possible playback?
- Previous by thread: Re: lost data, possible playback?
- Next by thread: Re: lost data, possible playback?
- Indexes: