View Full Version : postgresql login help
peter804
07-06-2009, 10:04 PM
Hi,
I have just brought holdem manager and i needed to install postgresql.
I have done this and it asks for my username and password, when it says this is incorrect would you like holdem manager to configure it, i say yes but it does nothing.
Thanks Pete
fozzy71
07-06-2009, 10:22 PM
When first installing postgresql there are 2 screens where you have to enter the password. That is the password it is wanting.
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=176
Default user name is: postgres
Typical passwords are: postgrespass and dbpass
If neither of those work, you can remove the need for a password by editing the pg_hba.conf file.
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
peter804
07-06-2009, 10:49 PM
cheers mate it worked, thanks for the quick reply :)
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.