public inbox for [email protected]  

help / color / mirror / Atom feed

From: Alvaro Herrera <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: Database Recovery
Date: Sun, 19 Dec 2004 21:41:32 -0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

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"

view thread (8+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Database Recovery
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox