restoring database too long

[aouriou]

Hi,

I've let pt4 run "restore" for at least 19 hours now (new SSD disk).
The backup file was 600MB. Estimated space required shows "12GB". PT4 is still active looking at the task manager.
Is this normal? Should i let it finish (eventually and hopefully)?
Or terminate it and import hands from disk?
Ideally i'd prefer the restore function because of some tour results that weren't tracked properly and had them edited manually.

Thanx

[kraada]

What does the restore window say? It should give you some idea what it's doing.

[aouriou]

it initially restored some smaller files like custom hugs, currencies etc.
Now it is stack at C:\Users\aouriou\AppData\Local\PokerTracker 4\ Processed/*.*... ...
the line with the dots got bigger as time went by but it still hasn't finished after 22 hours.
there's also a green loading bar underneath (next to the greyed-"Restore Now" button and "Cancel")

[kraada]

It's still restoring processed files - you can safely cancel it and restart the restore with Processed Files unchecked and it should proceed much faster.

[aouriou]

ok. but what about those processed hands? it's kinda the most important part, i can easily create a custom hud etc.
do i just wait until it's done if i want them?
try again with the restore function?
or "get hands from disk" function?

thanks for helping out and responding so quickly

[aouriou]

another question, if i stop the restore process now, will i have any processed hands at my database or none at all??
and should i do a "Full Cache Rebuild" ? (read it at a similar thread)

[WhiteRider]

The processed files are not required for your database - they are the original hand history files and are only needed should you ever need to re-import them again to a new database.
It will be quicker to skip them in the restore and just extract them if you ever need them at a later date.

The database will be restored in exactly the same state it was when you backed it up and doesn't need a cache rebuild as a matter of course.

[rbmrenato]

I am doing the restore that has lasted 26 hours and counting. My database had 102 GB before the backup, and the backup files (3 files) total 5.5 GB.

Is it normal to take so long?

I can't even tell if it crashed or if it continues to work and the process is so slow.

[Flag_Hippo]

A database of that size will take some time to restore especially if your not using an SSD. If PostgreSQL is still busy with the restore then you should see it using CPU in task manager however if PokerTracker 4 is at the stage where it is restoring processed files (if you enabled that option) you can cancel it and restart the restore with 'Processed Hands' unchecked. Processed hands are not required for your database to restore - they are the original hand history files and are only needed should you ever need to re-import them again to a new database. You can also extract them from the backup file if you ever need to use them again but restoring a large quantity of processed files will take some time.

[rbmrenato]

A database of that size will take some time to restore especially if your not using an SSD. If PostgreSQL is still busy with the restore then you should see it using CPU in task manager however if PokerTracker 4 is at the stage where it is restoring processed files (if you enabled that option) you can cancel it and restart the restore with 'Processed Hands' unchecked. Processed hands are not required for your database to restore - they are the original hand history files and are only needed should you ever need to re-import them again to a new database. You can also extract them from the backup file if you ever need to use them again but restoring a large quantity of processed files will take some time.

I am using a NVME SSD.
It's on processed hands for a long time.
The PT4 process on task manager is running with 7.5% CPU, but all PostgreSQL process is running on 0% CPU.

I really need the hands, i have a lot of marked hands that. It would be useful to know if it is running or if it is stuck.
The status output "...AppData\Local\PokerTracker 4\Processed/*.*.Restored" repeatedly without the time information or that it is new seems not to be very useful.

There are about 35 hours of restore so far, and I think some 34.5 of those are on processed hands.