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

Re: [HACKERS] Rebuilding DB from broken hardrive.

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: ylee(at)peragrin(dot)com
Cc: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [HACKERS] Rebuilding DB from broken hardrive.
Date: 2006-08-03 05:58:52
Message-ID: c2d9e70e0608022258w2fe52e0cne40bdea42129bffd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
i'm redirecting you to -general because -hackers is not the place for
this question.

some answers below

On 8/2/06, Yoon <ylee(at)peragrin(dot)com> wrote:
>
> I was trying postgres for about a year and the hard drive died.
> Using some block copy and other tools I was able to retrieve some data
> however it's missing directory names.
>
> Eventually, I was able to connect to my db. However, when I make a
> query. It comes back with following messages.
>
> WARNING: 4 attrdef record(s) missing <dbname>
> ERROR: could not open relation 1663/17230/17235: No such file.
>
> When I'm looking at my lost+found folder and
> recreating /var/lib/data/global and /var/lib/data/base/1.
>
> It would be nice to know how each directories are related to each other
> or at least a pointer to where I should look.
>

you need your backups instead... what? you don't have any backups?
then sorry, you need at least the entire data directory to be safe
(and that assuming you don't have any tablespace's pointing to another
location)

-- 
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

In response to

pgsql-hackers by date

Next:From: Simon RiggsDate: 2006-08-03 06:01:00
Subject: Re: Standby Mode
Previous:From: Gavin SherryDate: 2006-08-03 05:31:06
Subject: Re: Values list-of-targetlists patch for comments (was Re:

pgsql-general by date

Next:From: Just SomeoneDate: 2006-08-03 07:10:34
Subject: Re: SELinux + CREATE TABLESPACE = ?
Previous:From: David FetterDate: 2006-08-03 01:24:40
Subject: Re: SELinux + CREATE TABLESPACE = ?

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