Every 'solution' I have found I cant understand what it wants me to do.
For example
no clue what that means...

Only one clearly said to replace all the md5's w/trust in the pg_hba.conf file, which I did but that didnt help.

If anyone knows how to reset the password I would really appreciate it, thanks.

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

svcpass is another possibility


Go to your command function (for Vista users, type cmd in search) and type net user. This will show you which user groups are on your pc.

Net user will tell you what the user is on your machine.

If you still can't get connected thru HM you can either try to remove the password requirement entirely.


Start > Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf

The file should open with Notepad

Scroll to the bottom where you will see this code

[PHP]

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5
[/PHP]

You need to change the first 'md5' to 'trust', like this

[PHP]

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 md5
[/PHP]


Save, and close the file.

Click: Start > Programs > PostgreSQL 8.3 > Reload configuration

thank you for trying, unfortunately it didnt work.

I have the name of the database, but the passwords do not work. I went into pg_hba.conf and made the changes then ran 'reload configuration' then tried all the passwords again but they did not work.

Maybe you need to start the service after what Fozzy suggested - Control Panel/Administrative Tools/Services and find postgres and start it - set startup type to automatically also.

friendly bump

What was this originally installed for? PT3? I am guessing you made a unique username and/or password.

See if this helps:

http://forumserver.twoplustwo.com/sh...ostcount=14138


Otherwise I would suggest a reinstall of sql 8.3 and try to reuse your \data folder, although this may actually require 2 installations. Once to get a copy of the default pg_hba.conf and other files (except postmaster.pid) and then another installation to reinstall your old database with those new default config files.

These faqs refer to what I was just discussing:

http://www.holdemmanager.net/faq/afm...aspx?faqid=177

http://www.holdemmanager.net/forum/s...ead.php?t=8261


or else go with a new 8.4 installation and import your archives.

it was originally installed for the pt3 trial, for the last ~6 months HEM.

Thanks for the links I'll go through them now.

Thanks for the help again

If you need help with any of it:

Please email me at [email protected] so we can schedule a Teamviewer session. Download the www.Teamviewer.com Quick Support Module. It does not need to be installed, as it can run directly from your Desktop/Directory. Please let me know what time zone you are in and what time/days are convenient for you.

I've tried all of those things and it still wont work. The only difference is now i have like 4 empty new databases that hem wont connect to.

I dont know if this could be the problem:


I have clearly turned off User access control (and rebooted several times since), yet hem still brings up that warning as it tries to connect, im not sure if thats standard or not.

I am not sure what is going on, but I would be glad to take a look at it for you and try to help.

Please email me at [email protected] so we can schedule a Teamviewer session.