Cannot connect to SQL server

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

Cannot connect to SQL server

Postby Wodge » Sun Oct 12, 2008 11:20 am

I get the following message, Unable to begin feeder import process. Reason: 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 am sure I set the port to 5433 when I installed as I run PT2 with Postgres data running on port 5432, can't find a way to reset other than starting a new database. PC has been switched off for over a week so not sure if it has somehow defaulted back to port 5432.
Wodge
 
Posts: 5
Joined: Fri Mar 21, 2008 10:19 am

Re: Cannot connect to SQL server

Postby WhiteRider » Sun Oct 12, 2008 12:55 pm

This means that postgres isn't running.
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: Cannot connect to SQL server

Postby Wodge » Sun Oct 12, 2008 2:07 pm

Thanks for the quick reply. I have tried all of this as suggested. I notice that when looking at database details on PT3 it shows running on port 5432, the data base is running on 5433. I have tried changing the port thru the Admin app so that it is running on 5432 with no joy. I can't see a way of changing it in the PT client other than creating a new database. I need to backup my current database before I try this, presently looking for it. PT3 doesn't appear to have same backup facilities as PT2.
Wodge
 
Posts: 5
Joined: Fri Mar 21, 2008 10:19 am

Re: Cannot connect to SQL server

Postby Wodge » Sun Oct 12, 2008 3:10 pm

OK the old system restore trick sorted it out.
Wodge
 
Posts: 5
Joined: Fri Mar 21, 2008 10:19 am


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests