View Full Version : External/Separated HDD for HEM/SQL?

10-14-2009, 01:02 AM

I have bought a 2nd HDD for my computer and I would like to use that HDD only for HEM or the SQL Database. I think I found some website a while ago where it was mentioned that you would get a good increase of speed with that.

But how do I actually get postgreSQL to make the DB not on my C:\ but on the other dirve? Do I have to install Postgre on the other drive or can I set this somewhere in some kind of installer/options?

thx for the help

10-14-2009, 02:48 AM
The simple way is to reinstall and point the postgresql installer to the new data directory location.

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 reinstalling SQL to the same DB, 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\8.x\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.