PT4 Validate Statistics, PostgreSQL problem, impHM2 database

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

PT4 Validate Statistics, PostgreSQL problem, impHM2 database

Postby troshachaa » Wed Jun 21, 2023 4:18 pm

Hi,

Can you please help me.

I have PostgreSQL 9.3 woring with HM2.
I read in a post here that its good to download PostgreSQL 12.x, is that correct?
When I installed PT4, tried to import 1.4mil hands from HM2 db, some of them are omaha and i dont have that lycense here, the loading bar stucked at 1500 hands and didnt move for 30 min. It showed that the some hands are Omaha and thats the problem. Then I tryed again and this pup up showed.

https://upload-pictures.info/image-575B_649359DC.jpg

Now even if I upload one .txt file that message pop up every time.
When I open PT4, it shows that -
https://upload-pictures.info/image-9E8F_64935AD4.jpg

What to do?
Thank you for your time!
troshachaa
 
Posts: 3
Joined: Wed Jun 21, 2023 4:01 pm

Re: PT4 Validate Statistics, PostgreSQL problem, impHM2 data

Postby Flag_Hippo » Thu Jun 22, 2023 5:39 am

PostgreSQL v12 is recommended and you can download that from here. If you leave v9.3 installed then the new install should use port 5433 (you should also use the same password that you are currently using with Holdem Manager 2 & PokerTracker 4). When you have connected PokerTracker 4 to PostgreSQL v12 you can then manually import the hands you need into a new database using 'Play Poker -> Get Hands From Disk'. Please note that import speeds can drop over large imports so we recommend splitting larger imports into batches starting with your most recent hands as they will be more relevant.
Flag_Hippo
Moderator
 
Posts: 17131
Joined: Tue Jan 31, 2012 7:50 am

Re: PT4 Validate Statistics, PostgreSQL problem, impHM2 data

Postby troshachaa » Thu Jun 22, 2023 5:06 pm

Is it 5433 or 5432 port? Because mine is 5432 by default.

I installed 4.15.34. Now it cant uplaoad PS hands. Whay is that?

Thank you.

https://upload-pictures.info/image-CCA7_6494B5A7.jpg
https://upload-pictures.info/image-A2CA_6494B645.jpg
troshachaa
 
Posts: 3
Joined: Wed Jun 21, 2023 4:01 pm

Re: PT4 Validate Statistics, PostgreSQL problem, impHM2 data

Postby Flag_Hippo » Fri Jun 23, 2023 4:45 am

troshachaa wrote:Is it 5433 or 5432 port? Because mine is 5432 by default.

5432 is the default port but as I mentioned if you already have v9.3 installed then installing another version of PostgreSQL should use port 5433 (because port 5432 is already in use).
troshachaa wrote:I installed 4.15.34. Now it cant uplaoad PS hands. Whay is that?

Newer versions of PokerTracker 4 have an updated database schema and databases using the updated schema are not compatible with older versions of PokerTracker 4.
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