On Sun, Dec 19, 2004 at 04:11:17PM -0800, Harry wrote: > I have just had a bit of a disaster with a database and found very > little material online about how to recover from a corrupted database. > This is not the first time I have had to recoover data from a postgres > database which was caused either by some hardware failure or my own > error (not sure which is worse).
> http://www.hjackson.org/blog/archives/2004/12/postgresql_data.html Huh, this sounds like transaction Id wraparound to me. Do you regularly run vacuums on the whole database? Did you ask for expert help on the lists before running to do whatever you did? -- Alvaro Herrera (<[EMAIL PROTECTED]>) "Entristecido, Wutra (canci�n de Las Barreras) echa a Freyr a rodar y a nosotros al mar" ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
