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 [EMAIL PROTECTED]: >> >> > >> > >> > 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/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
