Group: pgsql.admin


Subject: lost data, possible playback?
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 12/6/2007 12:22:45 PM
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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend