Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: lost data, possible playback?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Palle Girgensohn <girgen(at)pingpong(dot)net>
- 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 12:22:45 -0500
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. regards, tom lane
- Follow-Ups:
- Re: lost data, possible playback?
- From: Palle Girgensohn
- Re: lost data, possible playback?
- 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
- 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: