PDA

View Full Version : cant figure out installation



akredandblack
10-15-2009, 11:44 AM
I'm trying to install on the free trial and i got to the point where it says database control panel and has the ip port number login name and password and i followed the instructions to download postgreSQL but i get an error message that says the username/password is incorrect and if i would like holdem manager to configure. Then it says holdem manger updated username and password and to try to connect again does anyone know how to fix this?

Thanks

fozzy71
10-15-2009, 01:22 PM
It sounds like you may have had postgresql installed before and did not delete the postgres user before the new sql installation.



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




# 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


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




# 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



Save, and close the file.

Click: Start > Programs > PostgreSQL 8.3 > Reload configuration



Otherwise you can do a clean reinstall of postgresql if you dont care about the old data.


For uninstalling SQL please follow these steps:

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