PDA

View Full Version : Don't want to share DB anymore



housenuts
09-23-2009, 05:53 PM
For the last 6 months or so I've been sharing my DB between my laptop and desktop using an external hard drive.

I think my DB is pretty large now and it seems to run really slowly through the external hard drive. Also lately I've been playing 95% of my desktop.

I'd like to just get my database to run of the internal hard drive in my desktop hopefully for more speed.

What's the best way to revert the sharing process back to the original process? Obviously I'd like to keep all my information. Currently running postgres 8.3

Thanks

fozzy71
09-23-2009, 10:17 PM
Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Vista: Turn off UAC - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=73

Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

For uninstalling SQL please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) If you are moving the DB to a different drive/partition, manually cut or copy the \Postgresql\data directory to it's new location.
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install the same version of PostgreSQL as your current DB using these instructions - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
6) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation.

housenuts
09-25-2009, 09:23 PM
Ok. I will do that. I have a 27gb data file. There's definitely a ton of hands on there I don't feel like copying over. I have some observed hands and such I don't need.

Is there a way I can filter it out so I'm only copying over only the hands I played in?

fozzy71
09-25-2009, 09:59 PM
Ok. I will do that. I have a 27gb data file. There's definitely a ton of hands on there I don't feel like copying over. I have some observed hands and such I don't need.

Is there a way I can filter it out so I'm only copying over only the hands I played in?

Make sure you have properly configured an alias for any/all screen names you have.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=35


Select that alias and then go to Options > Purge Hands:

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=152

Purge all cash hands and then tourney hands that do not involve you. Make sure your alias is selected as the Do Not Delete Hands Played By: name.


Now purge all observed hands in the same manner. You will have to do this multiple times, to get rid of all the different game types, and make sure your alias is selected each time.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=107


http://i207.photobucket.com/albums/bb176/fozzy71/HEM/hm-purge-1c.png



Now export your entire DB to text files:

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173


Create a new DB and import those exported hands, from the purged DB.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146