unable to login to database(pt3db) reason: fatal:no pg_hha.c

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

unable to login to database(pt3db) reason: fatal:no pg_hha.c

Postby jpdpoker » Sun Jan 11, 2009 1:27 pm

HI I got this erron message in poker tracker on vista machine.

postsgres server is running

unable to login to database(pt3db) reason: fatal:no pg_hha.conf entry for host "::1",user "postgres",database "PT3 DB",ssl off
jpdpoker
 
Posts: 32
Joined: Fri Dec 19, 2008 11:23 pm

Re: unable to login to database(pt3db) reason: fatal:no pg_hha.c

Postby WhiteRider » Sun Jan 11, 2009 6:53 pm

How did you install postgres? Did PT3 installer do it for you?
Did you have PT3 running correctly before this?
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: unable to login to database(pt3db) reason: fatal:no pg_hha.c

Postby jpdpoker » Sun Jan 11, 2009 10:11 pm

was working 100% before problem occured!
jpdpoker
 
Posts: 32
Joined: Fri Dec 19, 2008 11:23 pm

Re: unable to login to database(pt3db) reason: fatal:no pg_hha.c

Postby WhiteRider » Mon Jan 12, 2009 6:03 am

The guy who normally covers this forum will be back on later today and he knows more about postgres than me, so I'm sure he'll be able to help you.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: unable to login to database(pt3db) reason: fatal:no pg_hha.c

Postby kraada » Mon Jan 12, 2009 11:47 am

Click Start --> Programs --> PostgreSQL --> Edit pg_hba.conf and add the following line to the bottom:
host all all ::1/128 md5
then save the file. Click Start --> Programs --> PostgreSQL --> Stop Services followed by Start --> Programs --> PostgreSQL --> Start Services and then you should be able to restart PT3 normally.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 12 guests

cron
highfalutin