PDA

View Full Version : chances of restoring database after windows crash?



w4ters
05-21-2009, 04:04 AM
Hello

My windows gave up its ghost yesterday. I can access all of the HDD but i'm unable to boot XP up or repair it. Is there a chance i can back up my database from the disk somehow?

Thank you

morny
05-21-2009, 12:04 PM
look for the following folder X:\Program Files\PostgreSQL\PostgreSQL8.3\Data you need to copy all the files from that Data folder.

Then reinstall PostgreSQL 8.3 to the same location on the new drive, stop the postgerSQL service by going to Start > All Programs > PostgreSQL > Stop Service then go to X:\Program Files\PostgreSQL\PostgreSQL8.3\Data and delete the contents on the new drive in the data folder and copy the data folder contents from the old drive to this location. The restart the PostgreSQL service Start > All Programs > PostgreSQL > Start Service and if all goes well it will connect without errors but its not always successful as sometime i think the permissions from the old drive interfere with access so you might need to fiddle around with that