PDA

View Full Version : Can't boot windows, how do I get my database?



rivernuts
09-22-2008, 11:40 PM
Hi,

I wasn't able to boot to windows xp, so I reinstalled windows on another hard drive and now I can access my original hard drive. Can someone please tell me how I'd go about getting my database and moving it to my new hard drive.

regards,
Ken

rivernuts
09-23-2008, 06:28 AM
Can I just copy the postgresql data folder to my new hard drive?

morny
09-23-2008, 08:55 AM
If you can get access to the old drive by adding it as a 2ndary hard drive then copy the data folder which will be located in C:\Program Files\PostgreSQL\PostgreSQL 8.2\Data

Also take note of the exact location it saved it in and create these folders in the new drive and then paste the files you copied from the data folder into the new data folder. Then reinstall the same version on the new drive i.e 8.2 or 8.3 but when you get to the page where you have to enter your username and password the 2nd time then please untick "Initialise Database Cluster" which basically tells it you have already files in the C:\Program Files\PostgreSQL\PostgreSQL 8.2\Data folder and youd like to use them and you should be fine.

rivernuts
09-23-2008, 08:17 PM
worked fine, thanks.