Re: Database Recovery - Mailing list pgsql-docs

From Alvaro Herrera
Subject Re: Database Recovery
Date
Msg-id 20041220004132.GA8996@dcc.uchile.cl
Whole thread Raw
In response to Database Recovery  (Harry <postituk@yahoo.com>)
Responses Re: Database Recovery
Re: Database Recovery
List pgsql-docs
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 (<alvherre[@]dcc.uchile.cl>)
"Entristecido, Wutra                     (canción de Las Barreras)
echa a Freyr a rodar
y a nosotros al mar"

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Docs build failure on plpgsql.sgml
Next
From: Tom Lane
Date:
Subject: Re: Database Recovery