PDA

View Full Version : postgreSQL problem



janez
09-22-2011, 08:16 AM
I'm was installing holdem manager trial version and in the end of the instal it pops up a window saying that postgreSQL is not working anymore. However, the instll completes and when i try to run holdem manager it says error running database. What can i do to fix that?

Thanks for the answers.

netsrak
09-22-2011, 08:52 AM
The postgresql service probably wasn't installed and so HM is not working.

Please try to download and install Postgresql 8.4 from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org).
Try to install it to a different folder like c:\postgres or d:\postgres.
If that fails too - Which operating system? Which firewall / virusscanner? Which error comes up during the installation?

janez
09-22-2011, 09:07 AM
extraxt: psqlint.exe...100%, and a pop up window: psqlint.exe is not working anymore......
i have windows 7 64bit

i can't install that 8.4 version because i don't have a password, remember, i tried to install a trial version of HM.

janez
09-22-2011, 04:45 PM
now i managed to install postgreSQL and now it says: error FATAL: 28 000 password authentication failed for users postgres.
i want to buy the whole version but i'm just afraid it won't work like this trial version seems not to be. :(

fozzy71
09-22-2011, 09:35 PM
now i managed to install postgreSQL and now it says: error FATAL: 28 000 password authentication failed for users postgres.
i want to buy the whole version but i'm just afraid it won't work like this trial version seems not to be. :(

The trial version is the same as the 'whole version'. The only limitation is the 15 days.

This problem you are having is related to postgresql. It is not technically a problem with HM, but rather the database engine used by HM.

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

Start HM > Options > Database Management > Password:

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://faq.holdemmanager.com/questions/82/Password+Issues+(PostgreSQL)/


If none of that works, reinstall postgresql using these directions:

*Please update to the latest beta - http://rvgsoftware.fileburst.com/HmBetaUpdate.exe

1) Uninstall PostgreSQL from the Windows Control Panel.
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator


net user postgres /delete

4) reboot.
5) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe


If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator


net user postgres /delete

4) reboot.
5) Install PostgreSQL 8.3.9 from this link - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

janez
09-24-2011, 03:10 PM
thank you very much, it's working now... :)

olliepower
09-25-2011, 01:16 AM
glad we could help.