Page 1 of 2

Which PostgreSQL version for poker tracker 4?

PostPosted: Tue Nov 03, 2020 9:26 pm
by IhateChoppedPots
I bought and installed pt4 but it didnt automatically install PostgreSQL so I have to do it manually. I installed PostgreSQL version 13 but im getting an error. Which version do I need to install?

Re: Which PostgreSQL version for poker tracker 4?

PostPosted: Tue Nov 03, 2020 10:56 pm
by IhateChoppedPots
IhateChoppedPots wrote:I bought and installed pt4 but it didnt automatically install PostgreSQL so I have to do it manually. I installed PostgreSQL version 13 but im getting an error. Which version do I need to install?



ok so i found on this site that version 9.6 works. However the page was updated in 2019 and not sure if any newer version works with PT4. I installed 9.6 and it works.

Re: Which PostgreSQL version for poker tracker 4?

PostPosted: Wed Nov 04, 2020 5:55 am
by Flag_Hippo
Newer PostgreSQL versions such as v12 and v13 haven't been extensively tested with PokerTracker 4 and v9.6 is still our recommended version at this time.

Re: Which PostgreSQL version for poker tracker 4?

PostPosted: Wed Jun 16, 2021 11:34 pm
by ommaha
Which is the recommended PostgreSQL version by now? Thank you

Re: Which PostgreSQL version for poker tracker 4?

PostPosted: Thu Jun 17, 2021 5:22 am
by Flag_Hippo
PokerTracker 4 supports up to PostgreSQL v10 so we recommend using that or PostgreSQL v9.6.

Re: Which PostgreSQL version for poker tracker 4?

PostPosted: Sun Jun 27, 2021 7:44 pm
by ommaha
That sounds good. How do I do the upgrade to postgres 10 that the easiest/safest?

Save and backup everything (and manually save user data folder), then just uninstall postgres 9.3 and pokertracker, then reinstall postgres 10 and pokertracker, then make a new DB and import all hands there? Replace a couple of files in the user data folder for having the custom stats and player notes available again?

Re: Which PostgreSQL version for poker tracker 4?

PostPosted: Mon Jun 28, 2021 5:37 am
by Flag_Hippo
All that would be required is the backing up of your database(s), uninstalling PostgreSQL v9.3, installing PostgreSQL v10 and then restoring your database(s) in PokerTracker 4. There is no need to uninstall/reinstall PokerTracker 4 or do anything with your user data folder and reimporting hands wouldn't be necessary:

Guide: Backup & Restore

Re: Which PostgreSQL version for poker tracker 4?

PostPosted: Sun Feb 05, 2023 11:15 am
by Finnster
since I just reinstalled and need a PostgreSQL 13 for other work, I'd appreciate if I could use the same one for PT4.
So when you say that PT4 supports PostgreSQL 10 and 9, but higher version like 12 or 13 aren't extensively tested yet, does that mean it's just not tested or is there reason to believe that it won't work properly?

Re: Which PostgreSQL version for poker tracker 4?

PostPosted: Sun Feb 05, 2023 1:35 pm
by WhiteRider
It will likely work if PT4 will connect to it. We have seen some issues with connecting with PostgreSQL 14 because it uses a newer protocol, but I don't know whether that applies to 13.

Re: Which PostgreSQL version for poker tracker 4?

PostPosted: Sun Feb 05, 2023 6:05 pm
by Finnster
thanks for the reply. I guess the connections issues already start with 13 and not just 14.

luckily it's possible to have multiple Postgres instances running in different versions. But it seems the ice is getting a bit thin:

Postgres 9.6 failed to install on Win11.
Postgres 11.18 can't be downloaded, seems to be a bug on the postgres site.
Postgres 12.13 successfully installed and PT4 can connect.