Time length to restore large PT4 database

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Re: Time length to restore large PT4 database

Postby Flag_Hippo » Mon Mar 26, 2018 8:24 am

That is too long for a backup file of that size so please cancel that and restart the restore with "Processed Hands" unchecked and your database should restore much faster.
Flag_Hippo
Moderator
 
Posts: 17070
Joined: Tue Jan 31, 2012 7:50 am

Re: Time length to restore large PT4 database

Postby Bakourin » Sat Jun 13, 2020 11:45 am

Thought I'd rather post here instead of opening a new topic since my issue is very similar.

Long story short, Windows installation was unrecoverable after recent update , clean installed, restoring PT4 Database backup.

The restore has been running for about 24h at this stage, and from what I can tell by reading the status window, it's still restoring Stats-Custom stats.
e.g AppsData/Tm90ZUNhZGR5/definitions/backup_2020-03-05/call5bet.n2d

backup ZIP file size total is ~4GB (in 2 parts) , and estimated space required is ~80GB.

PT4 has been responsive and using CPU thru the entire process, however at this rate the restore may end up taking several days?

I am wondering, would I simply be better off re-running the restore with different parameters? or even trying to re-import everything through the processed folder at this point?

old DB was using POSTGRESQL 9.0 where new installation is using 9.3, but according to PT4 guides that 's not an issue when restoring backups.

Here's a SS showing current settings and progress

[ img ]
Bakourin
 
Posts: 2
Joined: Thu Sep 19, 2013 1:28 pm

Re: Time length to restore large PT4 database

Postby Flag_Hippo » Sat Jun 13, 2020 1:52 pm

NoteCaddy creates multiple backups of definitions and this can slow down the restore process. I recommend restoring again with 'User Data Files' disabled and if you have custom HUDs/statistics/reports e.t.c. that you need to recover you can manually extract the 'Data' folder from the backup file.
Flag_Hippo
Moderator
 
Posts: 17070
Joined: Tue Jan 31, 2012 7:50 am

Re: Time length to restore large PT4 database

Postby Bakourin » Tue Jun 16, 2020 12:34 pm

Ty for response, without User data it was a matter of hours for the restore to complete, and was able to move the files from the data folder as you suggested
Bakourin
 
Posts: 2
Joined: Thu Sep 19, 2013 1:28 pm

Re: Time length to restore large PT4 database

Postby Flag_Hippo » Wed Jun 17, 2020 3:21 am

Thanks for updating.
Flag_Hippo
Moderator
 
Posts: 17070
Joined: Tue Jan 31, 2012 7:50 am

Previous

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 24 guests