Date: Sun, 19 Dec 2004 21:41:32 -0300
From: Alvaro Herrera <alvherre@dcc.uchile.cl>
To: harry@uklug.co.uk
Cc: pgsql-docs@postgresql.org
Subject: Re: Database Recovery
Message-ID: <20041220004132.GA8996@dcc.uchile.cl>
References: <20041220001118.87459.qmail@web50403.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <20041220001118.87459.qmail@web50403.mail.yahoo.com>
User-Agent: Mutt/1.5.6i

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"