PDA

View Full Version : i have formated my hard drive


A.Kmicic
10-09-2008, 02:08 PM
postgres (8.2) was on another partition, how can i now make it work so that i can still use my database?
morny
10-09-2008, 02:20 PM
Use the backup and restore feature described in this FAQ http://208.109.95.123/faq/afmviewfaq.aspx?faqid=12
A.Kmicic
10-09-2008, 02:24 PM
i didnt do backup :/
morny
10-09-2008, 02:26 PM
If the drive you kept postgreSQL on is now formatted its gone you cant back it up after you delete it.

Did you keep the original HH, you can import them if you did
A.Kmicic
10-09-2008, 02:28 PM
i have postgreSQL on another partition, but i have new windows installed now and no postgreSQL installed, i cant make a backup
morny
10-09-2008, 03:29 PM
On the partition with PostgreSQL installed navigate to C:/Program Files/PostgreSQL/PostgreSQL8.3/Data and copy all the files there

Then create the following directory on your new drive C:/Program Files/PostgreSQL/PostgreSQL8.3/Data and paste the files in there

The install PostgreSQL 8.3 and make sure it installs to C:/Program Files/PostgreSQL and when you get to the section during installation where it asks for your username and password a 2nd time untick initialise database cluster and finish the installation