PDA

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 :)