View Full Version : postgres not working after client crash (mac)

09-26-2009, 08:35 AM
okay this is not really about HEM but i didnt know where to post it..

i run the newest HEM with postgresql on snowleopard and HEM/PRIMA client via parallels winxp

it was really easy to setup just installed postgres for mac and did the normal stuff in windows and connected with my ip instead of worked like a charm for over a month

but prima crashes from time to time (had the problem although with my dell) and everything was frozen and i had to reboot

and now my postgres isnt starting anymore (freezing reboot etc happend before this not) nothing happens when i click start in the prefs..
i dont have any clue with console commands and stuff like this esp in macos

i figured i need to restore my db but this is running for 9hours now and my db is not really big after a month...

here a screenshot


http://img19.imageshack.us/img19/9812/screenshot20090926at210.th.png (http://img19.imageshack.us/i/screenshot20090926at210.png/)

so how do i reinstall postgres in mac or just wait or a different command ? idk

help pls

09-26-2009, 09:30 AM
I have no experience with a MAC. On a PC that error usually means a firewall or similar program is blocking the connection for the DB.

These are the instructions I would suggest for a PC user:

First try a simple reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

Please try following all of these FAQs, step by step:

1) http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
2) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help at all we may want to schedule a remote support session to assist you.

After that I usually try to reinstall postgresql using their old DB a couple different ways, and if I still cant get connected we will end up reinstalling SQL clean, with a new DB. The customer will then have to import their processed/archived hands to rebuild the DB.

For using the old DB:

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.

For installing a clean DB:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows

09-26-2009, 11:50 AM
okay it was a problem with mac postgresql 8.4.0 and it was fixed with 8.4.1

now its working again but i lost my db :(

09-26-2009, 03:09 PM
You should be able to import your processed/archived files and/or request your old hands from your poker site.

Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

To verify the location: Options > Configure Auto Import Folders > Edit > Archive Folder: ___________________


The archive folder is also stored in the holdemmanager.config file.