Page 1 of 2

DATABASE problems

PostPosted: Sat Mar 19, 2016 12:24 am
by EA2USN
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?

Re: DATABASE problems

PostPosted: Sat Mar 19, 2016 9:14 am
by Flag_Hippo
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.

Re: DATABASE problems

PostPosted: Sat Mar 19, 2016 10:04 pm
by EA2USN
no postmaster.pid file there

Re: DATABASE problems

PostPosted: Sun Mar 20, 2016 7:04 am
by Flag_Hippo
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?

Re: DATABASE problems

PostPosted: Sun Mar 20, 2016 8:50 am
by EA2USN
windows could not start Postgresql on local host. error 1053: program dd not start of respond in a timely fashon

Re: DATABASE problems

PostPosted: Sun Mar 20, 2016 11:53 am
by Flag_Hippo
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.

Re: DATABASE problems

PostPosted: Sun Mar 20, 2016 1:30 pm
by EA2USN
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.

Re: DATABASE problems

PostPosted: Sun Mar 20, 2016 1:34 pm
by EA2USN
Timed out waiting for server startup
also this is in there

Re: DATABASE problems

PostPosted: Sun Mar 20, 2016 4:59 pm
by Flag_Hippo
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.

Re: DATABASE problems

PostPosted: Sun Mar 20, 2016 5:30 pm
by EA2USN
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

highfalutin