Thread: Recover data from crashed HD
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
> > > 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/
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/
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/ > >