Re: Recover data from crashed HD

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(at)trade-india(dot)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/