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

Posted:
Sun Jan 11, 2009 1:27 pm
by jpdpoker
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
Re: unable to login to database(pt3db) reason: fatal:no pg_hha.c

Posted:
Sun Jan 11, 2009 6:53 pm
by WhiteRider
How did you install postgres? Did PT3 installer do it for you?
Did you have PT3 running correctly before this?
Re: unable to login to database(pt3db) reason: fatal:no pg_hha.c

Posted:
Sun Jan 11, 2009 10:11 pm
by jpdpoker
was working 100% before problem occured!
Re: unable to login to database(pt3db) reason: fatal:no pg_hha.c

Posted:
Mon Jan 12, 2009 6:03 am
by WhiteRider
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.
Re: unable to login to database(pt3db) reason: fatal:no pg_hha.c

Posted:
Mon Jan 12, 2009 11:47 am
by kraada
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.