PDA

View Full Version : Import DB/Hands from old installation ?



mr_mooray
07-03-2009, 09:52 AM
Recently had to install windows new on a new partition. However my old database is still on the other partition which no longer boots.

How can I import the hands from that database considering I cant simply start up the old program and export ?

netsrak
07-03-2009, 10:14 AM
Our FAQ is really a great feature: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177

mr_mooray
07-03-2009, 10:20 AM
Not sure I understand how that helps ?

I am on a completely new partition and have already installed postgres/Hem and made a new database? The only thing that I saw that was different in that guide was that I uncheck intiate datacluster? but unfortuantley i have already made a new installl..

fozzy71
07-03-2009, 11:17 AM
If you want to use your old data folders in a new installation, you are going to have to uninstall SQL and follow those instructions. You also need to be sure you are using the same version of PostgreSQL.

You must *fully* remove PostgreSQL if you want to install it again.

- Uninstall from control panel. add/remove programs (I prefer Revo Uninstaller)
- Manually delete the Program Files\Postgresql\Data folder that was installed, and copy your previous \data folder into place.
- run the command (no quote marks) - start > run > 'cmd' > "net user postgres /delete"
- reboot.
- install again, as admin, with UAC off.

Make sure to UnCheck "initiate the database cluster", and then you should be able to install without damaging your \data folder you put there. I have never done it personally, but I recall a thread on 2p2 about it. - http://forumserver.twoplustwo.com/45/software/postgres-upgrade-did-i-just-completely-f-myself-269850/