Skip site navigation (1) Skip section navigation (2)

Re: Database Recovery

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: harry(at)uklug(dot)co(dot)uk
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Database Recovery
Date: 2004-12-20 00:41:32
Message-ID: 20041220004132.GA8996@dcc.uchile.cl (view raw or flat)
Thread:
Lists: 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[(at)]dcc(dot)uchile(dot)cl>)
"Entristecido, Wutra                     (canciĆ³n de Las Barreras)
echa a Freyr a rodar
y a nosotros al mar"

In response to

Responses

pgsql-docs by date

Next:From: Tom LaneDate: 2004-12-20 00:52:25
Subject: Re: Database Recovery
Previous:From: Tom LaneDate: 2004-12-20 00:33:55
Subject: Re: Docs build failure on plpgsql.sgml

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group