PDA

View Full Version : problem with postgres installation



onealex
12-20-2009, 03:49 PM
http://img96.imageshack.us/img96/7549/bugsf.jpg

I've had issues lately with HEM after being infested by virus. I'm trying to re-install HEM and postgres but I'm blocking here. Ty for your help.

Patvs
12-20-2009, 05:38 PM
-1 Either remove the postgres user first: before you reinstall
C:/net user postgres /delete
http://forums.holdemmanager.com/showthread.php?t=22409

-2 or install it to a different directory: for example PostgreSQL 8.3a

-3 or nstall PostgreSQL 8.4 instead

onealex
12-20-2009, 07:07 PM
thanks for your help

fozzy71
12-20-2009, 07:17 PM
This is usually because you installed the PT3 trial (which installs postgresql automatically).

If you havent uninstalled it yet, you should be able to simply connect HM to the sql installation.

PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

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

If you find you need to reinstall postgresql completely, use these steps - http://forums.holdemmanager.com/showthread.php?t=20755