Re: Recover data from crashed HD - Mailing list pgsql-admin

From Nils-Erik Svangård
Subject Re: Recover data from crashed HD
Date
Msg-id 1035410035.795.6.camel@p-nisse
Whole thread Raw
In response to Re: Recover data from crashed HD  (<mallah@trade-india.com>)
List pgsql-admin
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/
>
>



pgsql-admin by date:

Previous
From: "Igor Georgiev"
Date:
Subject: Re: [HACKERS] Security question : Database access control
Next
From: John Doe
Date:
Subject: postgresql 7.2.1 and smp ?