connecting to database

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

connecting to database

Postby dharriss » Thu Nov 07, 2019 8:43 am

Hi guys, I'm a bit stuck and I hope someone can help me please. I recently bought a new laptop and downloaded PT4 and it works just fine. However, the old computer doesn't anymore. There's a box pops up saying it can't connect to the database and I should reconfigure whatever it is that needs reconfiguring. I've tried reading up on all this in the guides and hardly understand it, so I'm hoping you would dumb it down a bit for me. Thanks a lot
dharriss
 
Posts: 2
Joined: Wed May 07, 2014 2:13 pm

Re: connecting to database

Postby Flag_Hippo » Thu Nov 07, 2019 1:44 pm

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 try starting PokerTracker 4 again. If that does not help then 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? If the PostgreSQL service is not listed at all then it will need to be installed and we have a guide for that here. If the PostgreSQL service is listed but not starting then open the Event Viewer (in the same way - if you type 'event' you should see it). In the top left section, expand "Windows Logs" and click on "Application". Do you see any recent errors in the top center section for PostgreSQL? If you do let us know what they say.
Flag_Hippo
Moderator
 
Posts: 17131
Joined: Tue Jan 31, 2012 7:50 am

Re: connecting to database

Postby dharriss » Thu Nov 07, 2019 4:04 pm

Hey Matey...thanks a lot for your reply. I tried those things but it didn't help....then reading further in the guide it said it should be 64 bit, but I saw on the Task manager PT4 (32 bit), on both computers. Also there was a complicated speech about swapping hard drives and how you should first stop PostgreSQL. Now I had a new SSD installed on the old computer and that was definitely not done...they just copied everything over to the new drive as is. Could that be my problem? What do you think I should do?
dharriss
 
Posts: 2
Joined: Wed May 07, 2014 2:13 pm

Re: connecting to database

Postby Flag_Hippo » Fri Nov 08, 2019 8:21 am

dharriss wrote:it should be 64 bit, but I saw on the Task manager PT4 (32 bit), on both computers.

PokerTracker 4 is 32bit on Windows so that's OK although there are 64bit versions of PostgreSQL (the program where PokerTracker 4 stores your poker data) which should be used if your operating system is 64-bit.
dharriss wrote:Also there was a complicated speech about swapping hard drives and how you should first stop PostgreSQL. Now I had a new SSD installed on the old computer and that was definitely not done...they just copied everything over to the new drive as is. Could that be my problem? What do you think I should do?

I don't know exactly what has been done on your computer but if the drive was cloned before being swapped then please refer to my original reply and answer the questions. If things were just copy/pasted that will not work to transfer a program like PostgreSQL so you will need to reinstall it if the PostgreSQL service doesn't exist:

Guide: How to Manually Install or Reinstall PostgreSQL

When that's done you can restore from a database backup (if you have one) or reimport your hands (if you have them) using 'Play Poker -> Get Hands From Disk'.
Flag_Hippo
Moderator
 
Posts: 17131
Joined: Tue Jan 31, 2012 7:50 am


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 0 guests