public inbox for [email protected]  

help / color / mirror / Atom feed

From: Harry <[email protected]>
To: [email protected]
Subject: Re: Database Recovery
Date: Sun, 19 Dec 2004 17:29:51 -0800 (PST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

--- Tom Lane <[email protected]> wrote:
> Harry <[email protected]> writes:
> > Is there any material online on how to recover a corrupt postgresql
> > database?
> 
> There are dozens if not hundreds of case histories in the mailing
> list archives; the latest example is this thread:
> http://archives.postgresql.org/pgsql-hackers/2004-12/msg00479.php
> Feel free to try to pull something together from that info.

It was all the threads and a lot of googling that enabled me to get the
data back.

> However, the rule of thumb is "every problem is different".  If we
> could think of a cookbook procedure then we'd build an automated 
> recovery tool ... so you need to think more in terms of teaching than

> of giving recipes.

I agree, I am not a believer in recipes either. However, for most
people they have no idea where to start or what to do next. The first
place I went looking was postgres.org and I got more info peppered
through the mailing lists than in the docs (not a bad thing).

I spent all day yesterday reading about what other people had done and
trying to figure out what I could use to determine what/where my
problem was and how to go about *starting* to fix it. I found little on
the use of or how to use pg_filedump or pg_resetxlog, luckily for me
the latter has a man page. I also used a post from yourself to
determine that I had to use the "-l" option to pg_resetxlog to fix my
problem.

In hindsight I would have done some things differently, like posting to
one of the lists. If you think that it would be better for people to
ask the list and run from there then I will leave it.

Harry


=====
Harry
Join team plico. 
http://www.hjackson.org/cgi-bin/folding/index.pl


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250

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]
  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