Thread: Recover data from crashed HD

Recover data from crashed HD

From
Nils-Erik Svangård
Date:

Hello!

One of my harddrives crashed two day ago. Only the /lib och /usr
directories was on one of my other hd's.
The old hd can no longer be detected by the bios. I have reinstalled
everything now.
The data directory in the old /lib contains what I would guess is
postgresqls table data. Can I recover the data?
I have tried to overwrite the new installation with the old files, but
the old database is not there.

I am a newbie in SQL-land, does anyone know how to revcover the data?

/nisse





Re: Recover data from crashed HD

From
Date:
>
>
> Hello!
>
> One of my harddrives crashed two day ago. Only the /lib och /usr
> directories was on one of my other hd's.

Do you mean /lib which contained  the $PGDATA  is still accessable.
please try to locate the folder named "data" that contains folder like
base, pg_xlog , global , pg_clog etc.

In case such a folder is available to you , you can start the postmaster daemon
by specifying the PGDATA folder (-D) option.

please let us know if such folder is there , we can help you recoverver you data.

Regds
MAllah.




> The old hd can no longer be detected by the bios. I have reinstalled everything now.
> The data directory in the old /lib contains what I would guess is
> postgresqls table data. Can I recover the data?
> I have tried to overwrite the new installation with the old files, but the old database is not
> there.
>
> I am a newbie in SQL-land, does anyone know how to revcover the data?
>
> /nisse
>
>
>
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9'
> the postmaster



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/



Re: Recover data from crashed HD

From
Date:
CONGRATS!!

if your DB size is small consider pg_dumpall ing every nite and store it in a different
machine :-)


Regds
MALLAH.

> SOLVED!!
>
> I tried a tip of a earlier post
> - I wiped the new disk clean of all postgres packages.
> - I moved the old postgres lib dir to /var/lib/postgresql
> - did a apt-get install postgresql which installed postgres and all packages needed.
>
> During the installation process a message appeared the package has detected a data dir.
> Then it said that postmaster was running at pid 337, but there was no such process. I stopped
> the installation and removed the postmaster.pid file, and contiued the installation.
> Now it works great, I can access all old data.
>
> Thank you very much for the help
>
> /nisse
>
> ons 2002-10-23 klockan 20.23 skrev mallah@trade-india.com:
>>
>> >
>> >
>> > Hello!
>> >
>> > One of my harddrives crashed two day ago. Only the /lib och /usr directories was on one of
>> > my other hd's.
>>
>> Do you mean /lib which contained  the $PGDATA  is still accessable. please try to locate the
>> folder named "data" that contains folder like base, pg_xlog , global , pg_clog etc.
>>
>> In case such a folder is available to you , you can start the postmaster daemon by specifying
>> the PGDATA folder (-D) option.
>>
>> please let us know if such folder is there , we can help you recoverver you data.
>>
>> Regds
>> MAllah.
>>
>>
>>
>>
>> > The old hd can no longer be detected by the bios. I have reinstalled everything now. The
>> > data directory in the old /lib contains what I would guess is postgresqls table data. Can I
>> > recover the data?
>> > I have tried to overwrite the new installation with the old files, but the old database is
>> > not there.
>> >
>> > I am a newbie in SQL-land, does anyone know how to revcover the data?
>> >
>> > /nisse
>> >
>> >
>> >
>> >
>> >
>> > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill
>> > -9' the postmaster
>>
>>
>>
>> -----------------------------------------
>> Get your free web based email at trade-india.com.
>>    "India's Leading B2B eMarketplace.!"
>> http://www.trade-india.com/
>>
>>



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/



Re: Recover data from crashed HD

From
Nils-Erik Svangård
Date:
SOLVED!!

I tried a tip of a earlier post
- I wiped the new disk clean of all postgres packages.
- I moved the old postgres lib dir to /var/lib/postgresql
- did a apt-get install postgresql which installed postgres and all
packages needed.

During the installation process a message appeared the package has
detected a data dir.
Then it said that postmaster was running at pid 337, but there was no
such process. I stopped the installation and removed the postmaster.pid
file, and contiued the installation.
Now it works great, I can access all old data.

Thank you very much for the help

/nisse

ons 2002-10-23 klockan 20.23 skrev mallah@trade-india.com:
>
> >
> >
> > Hello!
> >
> > One of my harddrives crashed two day ago. Only the /lib och /usr
> > directories was on one of my other hd's.
>
> Do you mean /lib which contained  the $PGDATA  is still accessable.
> please try to locate the folder named "data" that contains folder like
> base, pg_xlog , global , pg_clog etc.
>
> In case such a folder is available to you , you can start the postmaster daemon
> by specifying the PGDATA folder (-D) option.
>
> please let us know if such folder is there , we can help you recoverver you data.
>
> Regds
> MAllah.
>
>
>
>
> > The old hd can no longer be detected by the bios. I have reinstalled everything now.
> > The data directory in the old /lib contains what I would guess is
> > postgresqls table data. Can I recover the data?
> > I have tried to overwrite the new installation with the old files, but the old database is not
> > there.
> >
> > I am a newbie in SQL-land, does anyone know how to revcover the data?
> >
> > /nisse
> >
> >
> >
> >
> >
> > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9'
> > the postmaster
>
>
>
> -----------------------------------------
> Get your free web based email at trade-india.com.
>    "India's Leading B2B eMarketplace.!"
> http://www.trade-india.com/
>
>