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

Unable to login to database

Postby DDrop » Fri Jul 04, 2008 5:09 pm

Start Pokertracker3 - writes "loading.." than - "Unable to login to database (PT3 DB). Reason: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" and accepting TCP/IP connections on port 5432?"
I installed PT3 with postresql, created database "localhost" (default), imported hands, all was ok, but now after i entering a code, writes this error
DDrop
 
Posts: 2
Joined: Wed Jul 02, 2008 2:27 pm

Re: Unable to login to database

Postby keggler » Fri Jul 04, 2008 6:36 pm

is the postgres postmaster service running when you get this error?


susan
keggler
 
Posts: 640
Joined: Sun Jun 01, 2008 4:53 am

Re: Unable to login to database

Postby DDrop » Sat Jul 05, 2008 7:23 pm

Yes, many postgres.exe in proccesses. I reinstalled PT and postsql, now he writes "Unable to login to database (PT3 DB). Reason: server closed the connection unexpectedly. This probably means the server terminated abnormall before or while processing the request."
DDrop
 
Posts: 2
Joined: Wed Jul 02, 2008 2:27 pm

Re: Unable to login to database

Postby kraada » Sat Jul 05, 2008 9:53 pm

Please check to make sure that your firewall is allowing PostgreSQL connections to be made. First, disable your firewall and see if you can connect to the PostgreSQL server. If you can, you should then enter your firewall settings and make an exception for Postmaster.exe and port 5432. Once this exception is made you will be able to restart your firewall and use it with PostgreSQL (and PokerTracker 3) without further issue.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Unable to login to database

Postby bghfktu » Mon Jul 07, 2008 6:27 am

I am having a similar problem. I can't find Postmaster.exe on my hard drive though. Only postmaster.opts and postmaster.pid
bghfktu
 
Posts: 17
Joined: Tue Feb 12, 2008 6:38 pm

Re: Unable to login to database

Postby bghfktu » Mon Jul 07, 2008 8:08 am

I installed procmon and it seems as though vsmon.exe (associated with my ZoneAlarm firewall) insists on closing postgres.exe even though I've given full rights to postgres.exe. I'll post in the ZoneAlarm forum to see if they know how to solve it.

It's strange since it worked after install but not after I rebooted. I tried reinstalling and again it works until I reboot.
bghfktu
 
Posts: 17
Joined: Tue Feb 12, 2008 6:38 pm

Re: Unable to login to database

Postby bghfktu » Tue Jul 08, 2008 7:16 am

I uninstalled Zonealarm and installed the Comodo firewall instead and now postgreSQL is working.
bghfktu
 
Posts: 17
Joined: Tue Feb 12, 2008 6:38 pm

Re: Unable to login to database

Postby keggler » Tue Jul 08, 2008 10:51 am

good to see you sussed it - procmon to the rescue once again... :D


susan
keggler
 
Posts: 640
Joined: Sun Jun 01, 2008 4:53 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 26 guests

cron
highfalutin