Error updating database

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Error updating database

Postby Gediminho » Wed May 29, 2024 8:53 pm

Today I tried to update my PT4 but in the end I got this errors

Is there a way I can do something to fix this issue?
Attachments
123.PNG
(574.19 KiB) Downloaded 3404 times
1234.PNG
(30.81 KiB) Downloaded 3423 times
12345.PNG
(56.41 KiB) Downloaded 3480 times
Gediminho
 
Posts: 1
Joined: Sat Oct 28, 2023 7:48 am

Re: Error updating database

Postby Flag_Hippo » Thu May 30, 2024 5:46 am

This issue only happens with very old PostgreSQL versions such as v8.4 which reached its end-of-life in 2014 and is below the minimum required version for PokerTracker 4. To fix the issue you will need to install and use PostgreSQL version v12 and then restore your database(s) - see this guide:

https://www.pokertracker.com/guides/PT4 ... postgresql
Flag_Hippo
Moderator
 
Posts: 17040
Joined: Tue Jan 31, 2012 7:50 am

Re: Error updating database

Postby junks » Fri May 31, 2024 7:53 pm

I'm getting this Fatal error with v.9.0.10

I'll try the upgrade
junks
 
Posts: 58
Joined: Sat Oct 18, 2008 5:31 pm

Re: Error updating database

Postby junks » Sat Jun 01, 2024 3:45 am

For Backup DB, if there's not enough Temp Space, how to select the other Hard Drive for Temp?
junks
 
Posts: 58
Joined: Sat Oct 18, 2008 5:31 pm

Re: Error updating database

Postby junks » Sat Jun 01, 2024 4:26 am

Update: I was able to change the TMP environment variable in Windows. All good.
junks
 
Posts: 58
Joined: Sat Oct 18, 2008 5:31 pm

Re: Error updating database

Postby junks » Mon Jun 03, 2024 5:15 pm

Postgres 12 installed... i followed your guide to set postgresql.conf

#log_timezone = 'America/New_York'
#timezone = 'America/New_York'

The Win10 timezone is (UTC -5:00) Eastern Time (US & Canada)

but I still get the PT4 timezone error
junks
 
Posts: 58
Joined: Sat Oct 18, 2008 5:31 pm

Re: Error updating database

Postby Flag_Hippo » Tue Jun 04, 2024 5:23 am

Your timezone entries have not been set correctly:

Alter the Time Zone Guide wrote:6. The # sign at the start of any line within the postgreql.conf file is used to comment out the property change defined by that line. If there is a "#" as the start of the timezone line, you must delete this character.

After making the change make sure to restart your computer or the PostgreSQL service before starting PokerTracker 4 again.
Flag_Hippo
Moderator
 
Posts: 17040
Joined: Tue Jan 31, 2012 7:50 am

Re: Error updating database

Postby junks » Sat Jun 08, 2024 4:56 am

Alter the Time Zone Guide wrote:6. The # sign at the start of any line within the postgreql.conf file is used to comment out the property change defined by that line. If there is a "#" as the start of the timezone line, you must delete this character.


oops thanks!
junks
 
Posts: 58
Joined: Sat Oct 18, 2008 5:31 pm


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 8 guests