Im getting some database error..

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Im getting some database error..

Postby forfuns » Wed Jun 01, 2016 12:00 pm

so when i try to run PT4 i get this message:
"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 connections on port 5432? "

After clicking configure defaults i get the connect to postgreSQL Server ... i click "connect" and then i get "Unable to connect to this database. Please check the configuration."

what to do ?
forfuns
 
Posts: 17
Joined: Wed Apr 27, 2016 2:10 pm

Re: Im getting some database error..

Postby kraada » Wed Jun 01, 2016 12:36 pm

Click Start type services.msc and click on it when it appears. Do you see PostgreSQL in the service list? If so can you start it?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Im getting some database error..

Postby forfuns » Wed Jun 01, 2016 12:55 pm

kraada wrote:Click Start type services.msc and click on it when it appears. Do you see PostgreSQL in the service list? If so can you start it?

umm... i see only "postgresql-8.4-PostgreSQL Server 8.4" and when i click on it ... theres no "start" button i cant find it ?
and no theres no "PostgreSQL" in the list

i dont understand whats the problem PT4 was working fine for weeks ... even this morning but now randomly dont work
forfuns
 
Posts: 17
Joined: Wed Apr 27, 2016 2:10 pm

Re: Im getting some database error..

Postby kraada » Wed Jun 01, 2016 2:56 pm

Start Service would be on the left hand side in the services window. Or you can right click and click Properties to see a button to start the service.

The error is saying that there is no PostgreSQL service running so the question is why isn't it running -- sometimes it's as simple as starting it up, sometimes there's a reason why it stopped but we need to know what that is before we can fix it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Im getting some database error..

Postby forfuns » Wed Jun 01, 2016 3:44 pm

kraada wrote:Start Service would be on the left hand side in the services window. Or you can right click and click Properties to see a button to start the service.

The error is saying that there is no PostgreSQL service running so the question is why isn't it running -- sometimes it's as simple as starting it up, sometimes there's a reason why it stopped but we need to know what that is before we can fix it.

so what do i do to get it fixed ? i got lots to grind this month and need my hud
forfuns
 
Posts: 17
Joined: Wed Apr 27, 2016 2:10 pm

Re: Im getting some database error..

Postby forfuns » Wed Jun 01, 2016 4:16 pm

forfuns wrote:
kraada wrote:Start Service would be on the left hand side in the services window. Or you can right click and click Properties to see a button to start the service.

The error is saying that there is no PostgreSQL service running so the question is why isn't it running -- sometimes it's as simple as starting it up, sometimes there's a reason why it stopped but we need to know what that is before we can fix it.

so what do i do to get it fixed ? i got lots to grind this month and need my hud


edit: i found the "start" button ...
when i "start" "postgresql-8.4-PostgreSQL Server 8.4" ... it loads a bit then i get this message: "Windows could not start the postgresql - PostgreSQL Server 8.4 service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion.
forfuns
 
Posts: 17
Joined: Wed Apr 27, 2016 2:10 pm

Re: Im getting some database error..

Postby forfuns » Thu Jun 02, 2016 12:16 am

any help ?
forfuns
 
Posts: 17
Joined: Wed Apr 27, 2016 2:10 pm

Re: Im getting some database error..

Postby WhiteRider » Thu Jun 02, 2016 3:32 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.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Im getting some database error..

Postby forfuns » Thu Jun 02, 2016 4:04 am

WhiteRider wrote: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.

here ? if u mean this

2016-06-02 11:01:48 EESTFATAL: could not create shared memory segment: 8
2016-06-02 11:01:48 EESTDETAIL: Failed system call was MapViewOfFileEx.
forfuns
 
Posts: 17
Joined: Wed Apr 27, 2016 2:10 pm

Re: Im getting some database error..

Postby kraada » Thu Jun 02, 2016 7:29 am

That's it. That is a known error that can happen with PostgreSQL 8.4 on newer operating systems. At this point in time there is no known solution. Do you have a backup of your hands or your database? If so the easiest and fastest way to get things up and running again will be to uninstall 8.4 fully and manually install PostgreSQL 9.3 per our guides here.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 44 guests

cron