Manually Importing Tablespaces from Postgres 8.0 beta-1 to Postgres 8.0 (for windows)
Posted on 2005-04-18
Hi All! Here's my problem, last year I setup an application on a pc running windows XP-Pro. The application uses JSP and PostgreSQL as its database. Last friday, the motherboard of the pc crashed due to age (its been around a long time).. we got it replaced, but unfortunately I'm getting the blue screen from XP Pro everytime I boot up, and during safe mode the pc just reboots entirely.
So is the hard drive was still intact I just opted to just extract the postgres data from it and just reformat the pc. I was able to copy over the entire postgres folder from the hard drive to my laptop, which has postgres 8.0 installed and running. My next step was to open the databases from the copied data and export them to scripts so that I can just run them later on the reformatted pc.
However, postgreSQL seems to have a rather unique way of laying out their tablespace data... so I'm having a difficult time figuring out how to open the databases... I've tried copying the contents of the data folder to a newly created tablespace folder, I've tried overwriting my installation's data folder and even tried switching the postgres installation entirely all to no avail....
At the moment I am going to install postgreSQL 8.0 beta on another PC and try the same list of procedures... however, if there is any other way I can do it easily, I would greatly appreciate the help... especially since I am not certain if my current attempt will work at all...
If you need me to clarify on anything in particular let me know... Thanks in advance for all your help!