PDA

View Full Version : copied postgreSQL file while it was still running



Puke
10-16-2008, 03:11 PM
So i copied the entire postgreSQL folder while it was still running, and now it states "Failed to establish a connection to '127.0.01 ' (the local host name)
I've tried stopping and restarting postgreSQL, i deleted the postmaster file but it still doesn't work.
Is there any way to get access of my data again? like reinstalling postgreSQL ?
also: i can't access the file on my old HD anymore

Thanks in advance

fabio
10-16-2008, 03:44 PM
ok, do this:

1.) Save your "data" folder. You can find it in C:\Program Files\PostgreSQL\8.3.
2.) Uninstall postgresql completely and delete everything under C:\Program Files\PostgreSQL\8.3. EXCEPT the data folder.
3.) Install PostgreSQL again, but untick "Initialize Database cluster".
4.) Launch HM and try to connect to your postgresql server with the database control panel, it will tell you that not connection could be established and Hm will start the service for you after that.
5.) click on "connect" again and it should work

Puke
10-17-2008, 01:23 AM
Thanks!
It worked, for now everything seems to be working fine