Unable to login to database .... Reason: FATAL

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 .... Reason: FATAL

Postby preparac » Thu Oct 02, 2008 5:47 pm

I'm running Beta 18 on my computer, untill a few days without problems. Now when I open it, PT3 starts, but give me no acces to my databases. I get followoming error message:

Unable to login to database (name of activ database) Reason: FATAL: np pg_hba.conf entry for host "::", user "postgres", database "name of activ database", SSL off

What this means and what to doo? Probably I messed up somenthing, because I mistankenly entered my Pokertracker license on THREE computers in my house? (And it was accepted...) But I need pokertracker on THIS computer! If this is the problem - can I take back the licence from the other computers? Or how to resolve this? An if not, what could be the problem?

Appreciate your help
preparac
 
Posts: 323
Joined: Thu May 15, 2008 6:23 am

Re: Unable to login to database .... Reason: FATAL

Postby WhiteRider » Fri Oct 03, 2008 4:46 am

I'll get someone to help you..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Unable to login to database .... Reason: FATAL

Postby prajna » Sun Oct 05, 2008 6:51 pm

Did you change your settings in your pg_hba.conf file? Copy paste your pg_hba.conf file here and we can see what is happening. It is located in computer -> c: -> program files -> postgresql -> 8.x (whatever version you see) -> data.

~ Thomas
[PokerTracker Support]
prajna
 
Posts: 734
Joined: Thu Apr 03, 2008 1:58 pm

Re: Unable to login to database .... Reason: FATAL

Postby defence18 » Wed Oct 08, 2008 2:45 pm

I'm having the same issue. I get this error:
"Unable to begin import process. Reason: Unable to login to database (PT3 DB). Reason: FATAL: database "PT3 DB" does not exist"
when trying to convert my PT2 db to PT3.
defence18
 
Posts: 13
Joined: Sat Aug 02, 2008 9:07 pm

Re: Unable to login to database .... Reason: FATAL

Postby WhiteRider » Wed Oct 08, 2008 5:35 pm

defence18 wrote:I'm having the same issue. I get this error:
"Unable to begin import process. Reason: Unable to login to database (PT3 DB). Reason: FATAL: database "PT3 DB" does not exist"
when trying to convert my PT2 db to PT3.

That doesn't sound like the same issue.
Do you have postgres installed and running?
Did you install PT3 with postgres?

IF you do have it installed, you'll need to start it.
Please try starting the postgres service: Start -> Programs -> PostgreSQL -> Start Service.
If that, and a reboot doesn't work, try stopping the service (Start -> Programs -> Postgres -> Stop Service), running a search on your computer for postmaster.pid and then deleting that file, then restarting the service and see if that helps.
Note that you may need to turn on 'View hidden files and folders', and the file seems to be in the folder './Program Files/postgresql//data'.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Unable to login to database .... Reason: FATAL

Postby defence18 » Tue Oct 14, 2008 2:12 am

Didn't solve the problem. I don't have a postmaster.pid file on my comp. I have a postmaster.opts though. I originally installed Postgres w/ PT3, but then I couldn't use that Postgres to recover my backup file for PT2, so I had to install an older version. After I recovered my database, I deleted the old Postgres, and installed 8.3 from their website.
defence18
 
Posts: 13
Joined: Sat Aug 02, 2008 9:07 pm

Re: Unable to login to database .... Reason: FATAL

Postby WhiteRider » Tue Oct 14, 2008 3:12 am

Did you get it working at all after you did your re-install / delete?

If not, have a look at this thread for a full re-install.
Total uninstall/reinstall of pt3
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests