PDA

View Full Version : alternate backup of hem db



amarillotg
10-11-2009, 10:59 AM
hi,

my computer that stores my hem db is pooched and i can only boot it up in safe mode. when going through the steps in the backup hem db im getting an error in pgadmin iii saying it can't connect to the server. (i believe my psw is correct)

thus i can't complete the backup and move it to another computer. is there any other way i can do this? can i simply copy the whole postgres folder over to my new computer?

tks,

tg

netsrak
10-11-2009, 01:18 PM
You need the data folder: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177

dan233
10-12-2009, 06:12 PM
You need the data folder: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177

Sorry but isnt something missing from this tutorial? Where does it explain how to establish a path between the previous database and postgres? is it a default location so it doesnt have to be set?

fozzy71
10-12-2009, 07:26 PM
It is a default location if you didnt change it. You click on the 'data directory' during installation to specify it.

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.