all of a sudden: error message "unable to login to database"

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

all of a sudden: error message "unable to login to database"

Postby Royal_23 » Mon Nov 24, 2008 7:34 pm

hi

earlier tonight i was using poktertracker as normal. everyrthing was fine. i exited the programme.

just now i wanted to continue playing and started PT3. in the lefthandside column where it usally lists the players there is now a red error message:

unable to login to database (PT3 DB). REason: FATAL: no pg_hba.conf entry for host "::1", user "postgres", database "PT3 DB", SSL off


what does this mean?
i did not change a THING since last using the software.

i am using the trial version and have 38 days left i think.
i restarted windows twice now, but the problem is still there.

i checked under start->programmes->potsgreSQL8.3 and that file the error message refers to is still there.

please help?
Royal_23
 
Posts: 5
Joined: Tue Jul 22, 2008 2:32 pm

Re: all of a sudden: error message "unable to login to database"

Postby WhiteRider » Tue Nov 25, 2008 5:27 am

I'll get someone who knows more about postgres to take a look.
WhiteRider
Moderator
 
Posts: 53972
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: all of a sudden: error message "unable to login to database"

Postby Royal_23 » Tue Nov 25, 2008 10:41 am

thanks, if you could that'd be great.
Royal_23
 
Posts: 5
Joined: Tue Jul 22, 2008 2:32 pm

Re: all of a sudden: error message "unable to login to database"

Postby kraada » Tue Nov 25, 2008 11:06 am

Click Start --> Programs --> PostgreSQL --> Edit pg_hba.conf

Scroll to the bottom, and add this line exactly as you see it here:

host all all ::1/128 md5

Then save and exit the file, and Start --> Programs --> PostgreSQL --> Reload Configuration and things should then work properly.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: all of a sudden: error message "unable to login to database"

Postby Royal_23 » Tue Nov 25, 2008 5:43 pm

thanks man!
you're my hero now.

that line was actually already in there, but prefixed with # (i believe that means it's commented out).
wonder why it changed at all... but it's all working now, that's the main thing!
Royal_23
 
Posts: 5
Joined: Tue Jul 22, 2008 2:32 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: MagPie Crawler and 17 guests

cron
highfalutin