View Full Version : Database on a new drive

08-28-2009, 08:17 AM
I have my default database on the system drive and I want to create an other (which is going to be a lot bigger one) on a different drive.
Is it possible?
I can't see any options in HEM when creating new DB and I don't know if it can be solved somehow in pgAdmin...

08-28-2009, 09:52 AM
You will need to move your entire posgresql database to your new drive. It will probably be easiest to reinstall SQL to the new drive and use your old DB during install. Then you can use that DB, or create a new one. That 2nd HD should also help your DB performance.

I've recently bought a new hard drive and I would like to transfer my Holdem Manager database to the new hard drive, as it is taking up too much space on my old one. How would I go about doing this? (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=101)

How do I re-install PostgreSQL and use a previous database? (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177)

I would also suggest you make a backup file of your DB, and export your entire DB to text files, before doing this. That way all of your hands are backed up, if something goes wrong and you have to reimport to rebuild the DB.



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) manually delete the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) install PostgreSQL again, with your firewall uninstalled or turned off if windows firewall.