PT4 DB connection issue after Win10 update

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

PT4 DB connection issue after Win10 update

Postby Sevikar20 » Sat Dec 09, 2017 9:19 am

please see the attachment

im unable to connect to Progres SQL database after my recent Windows 10 update

could you please help me?

Thanks
Attachments
PT4 DB connection issue 3.PNG
PT4 DB connection issue 2.PNG
PT4 DB connection issue 2.PNG (3.65 KiB) Viewed 1698 times
PT4 DB connection issue 1.PNG
Sevikar20
 
Posts: 41
Joined: Thu Aug 02, 2012 9:44 am

Re: PT4 DB connection issue after Win10 update

Postby Sevikar20 » Sat Dec 09, 2017 9:26 am

i have version 9.0 and get following error when launching postgres sql
Attachments
PT4 DB connection issue 5.PNG
PT4 DB connection issue 5.PNG (3.37 KiB) Viewed 1696 times
Sevikar20
 
Posts: 41
Joined: Thu Aug 02, 2012 9:44 am

Re: PT4 DB connection issue after Win10 update

Postby Sevikar20 » Sat Dec 09, 2017 10:48 am

can you please help?

I'm a bit desperate, I've tried all proposed solution found online on different forums but without success yet
Sevikar20
 
Posts: 41
Joined: Thu Aug 02, 2012 9:44 am

Re: PT4 DB connection issue after Win10 update

Postby Flag_Hippo » Sat Dec 09, 2017 1:43 pm

Is your Windows/PostgreSQL using a Czech locale? If so you'd want to refer to this link for further details. If not then 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 fix things 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 service is listed but not starting open the Event Viewer (in the same way - if you type 'event' after clicking your start button 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: 15550
Joined: Tue Jan 31, 2012 7:50 am

Re: PT4 DB connection issue after Win10 update

Postby Sevikar20 » Sat Dec 09, 2017 9:08 pm

thanks Flag_Hippo

postmaster.pid not present
I'm not using a Czech Locale
I cannot start PostgreSQL present in services.msc, i got the error message I attached above
I see a bunch of events errors but none for Postgres SQL seems like.
see some errors in the attachments that happen at the time of trying to run PT4 and Postgres SQL

thanks for your help
Attachments
events 3.PNG
events 3.PNG (7.4 KiB) Viewed 1672 times
events 2.PNG
events 2.PNG (10.95 KiB) Viewed 1673 times
events 1.PNG
Sevikar20
 
Posts: 41
Joined: Thu Aug 02, 2012 9:44 am

Re: PT4 DB connection issue after Win10 update

Postby Sevikar20 » Sat Dec 09, 2017 11:07 pm

i don't seem to get any log errors from postgres SQL
i've researched the web extensively and just can't find a solution
this is really frustrating in the middle of grind. can you contact me directly and work out sth via Teamviewer?
Sevikar20
 
Posts: 41
Joined: Thu Aug 02, 2012 9:44 am

Re: PT4 DB connection issue after Win10 update

Postby Sevikar20 » Sat Dec 09, 2017 11:43 pm

my local is French(Switzerland). I've re-installed the czech locale following the instructions but without success in restarting postgres
it shows me an "error 2: the system cannot find the file specified"
Attachments
PT4 DB connection issue 5.PNG
PT4 DB connection issue 5.PNG (3.37 KiB) Viewed 1664 times
Sevikar20
 
Posts: 41
Joined: Thu Aug 02, 2012 9:44 am

Re: PT4 DB connection issue after Win10 update

Postby Sevikar20 » Sun Dec 10, 2017 12:51 am

Update: i found solution. services msc --> postgres --> the path to execute was wrong. it was put C://... instead of D://.
I found a way to change it to correct path and every thing work smoothly

For people with similar porblems, check out the video made by HoldemManager on postgresql connection issues, it has a lot of good troubleshooting that may work
Sevikar20
 
Posts: 41
Joined: Thu Aug 02, 2012 9:44 am

Re: PT4 DB connection issue after Win10 update

Postby Sevikar20 » Sun Dec 10, 2017 5:12 am

I see today's hands being read by PT4 and Postgres running smoothly.

For some reason, the HUD is not working. I tried to restart HUD and PT4, without success. Hands are also not able to be tagged which seem connected with the issue. see some attachments

What can i do here Flag_Hippo? I need my HUD :)
Attachments
pt4 issue v2.JPG
pt4 issue.JPG
Sevikar20
 
Posts: 41
Joined: Thu Aug 02, 2012 9:44 am

Re: PT4 DB connection issue after Win10 update

Postby Sevikar20 » Sun Dec 10, 2017 6:55 am

I've rebuilt the cache of my unique database, the icon pt4 is showing up on the table but the HUD is simply not there after hundred of hands played
What else can I do?
Sevikar20
 
Posts: 41
Joined: Thu Aug 02, 2012 9:44 am

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 72 guests

cron
highfalutin