DATABASE problems

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

DATABASE problems

Postby EA2USN » Sat Mar 19, 2016 12:24 am

I was on earlier then a few hours later im getting this msg. Unable to login to database (postgres). Reason: could not connect to server. Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connedtions on port 5432?

any ideas how to get on to poker tracker?
EA2USN
 
Posts: 66
Joined: Sat May 17, 2008 10:05 pm

Re: DATABASE problems

Postby Flag_Hippo » Sat Mar 19, 2016 9:14 am

Locate and delete the postmaster.pid file if it is present (not "postmaster.opts" which may be there too). You can find that file in C:\Program Files\PostgreSQL\9.3\data\ although you may have a different PostgreSQL version (e.g. 8.4, 9.0) or have it installed in C:\Program Files (x86). Once it's deleted, reboot and see if that resolves the trouble.
Flag_Hippo
Moderator
 
Posts: 14516
Joined: Tue Jan 31, 2012 7:50 am

Re: DATABASE problems

Postby EA2USN » Sat Mar 19, 2016 10:04 pm

no postmaster.pid file there
EA2USN
 
Posts: 66
Joined: Sat May 17, 2008 10:05 pm

Re: DATABASE problems

Postby Flag_Hippo » Sun Mar 20, 2016 7:04 am

Click your Windows Start button then type the following command:

services.msc

and click on it when it appears. Do you see the PostgreSQL service in the list? Is it started, or can you start it?
Flag_Hippo
Moderator
 
Posts: 14516
Joined: Tue Jan 31, 2012 7:50 am

Re: DATABASE problems

Postby EA2USN » Sun Mar 20, 2016 8:50 am

windows could not start Postgresql on local host. error 1053: program dd not start of respond in a timely fashon
EA2USN
 
Posts: 66
Joined: Sat May 17, 2008 10:05 pm

Re: DATABASE problems

Postby Flag_Hippo » Sun Mar 20, 2016 11:53 am

Click Start type Event Viewer and click on it when it appears. Expand the Windows Logs section in the top left and click Applications. In the top center pane you should see errors relating to PostgreSQL. Click on one and tell us what the error text (in the bottom center) says.
Flag_Hippo
Moderator
 
Posts: 14516
Joined: Tue Jan 31, 2012 7:50 am

Re: DATABASE problems

Postby EA2USN » Sun Mar 20, 2016 1:30 pm

2016-03-20 09:39:00 EDT FATAL: could not create shared memory segment: 8 2016-03-20 09:39:00 EDT DETAIL: Failed system call was MapViewOfFileEx.
EA2USN
 
Posts: 66
Joined: Sat May 17, 2008 10:05 pm

Re: DATABASE problems

Postby EA2USN » Sun Mar 20, 2016 1:34 pm

Timed out waiting for server startup
also this is in there
EA2USN
 
Posts: 66
Joined: Sat May 17, 2008 10:05 pm

Re: DATABASE problems

Postby Flag_Hippo » Sun Mar 20, 2016 4:59 pm

That particular message from the Event Viewer usually means security software on your computer is preventing PostgreSQL from starting when your computer does. If you're using any security software (such as antivirus, firewall), please make sure to follow the instructions given in the Security Software Configuration Guide to see if that resolves your problems. If it doesn't what you can do is this:

1. Temporarily uninstall all security programs (firewalls, anti-virus/malware, etc.). Disabling them or turning them off won't be enough.

Don't visit other web sites, download other files or emails until they're reinstalled.

2. Reboot your computer.

3. Start PokerTracker4 and see if it will run now - if it does that means PostgreSQL is now able to start up.
Flag_Hippo
Moderator
 
Posts: 14516
Joined: Tue Jan 31, 2012 7:50 am

Re: DATABASE problems

Postby EA2USN » Sun Mar 20, 2016 5:30 pm

I dont know, I havent changed my software at all, I did upgrade to windows 10 but pt ran fine for a few days after the upgrade. I was using Postgresql 8.3 I just downloaded the newest version 9.5 and PT oppened however I can not access my old data base's had to create a new database
EA2USN
 
Posts: 66
Joined: Sat May 17, 2008 10:05 pm

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 97 guests

cron