Backup

[Roquim]

Hello Guys,

I am trying to backup my DB and i got this message on the final:

Checking disk space needed for backup...OK
Starting Backup...
Creating temporary folder
-------------------
Databases
-------------------
Database: PokerTracker 4 Database...pg_dump: Cópia do conteúdo da tabela "tourney_hand_summary" falhou: PQgetResult() falhou.
pg_dump: Mensagem de erro do servidor: ERROR: invalid memory alloc request size 4294967293
pg_dump: O comando foi: COPY public.tourney_hand_summary (id_hand, id_gametype, id_site, id_tourney, id_blinds, id_table, hand_no, date_played, date_imported, cnt_players, cnt_players_lookup_position, cnt_players_f, cnt_players_t, cnt_players_r, amt_pot, amt_short_stack, amt_pot_p, amt_pot_f, amt_pot_t, amt_pot_r, str_actors_p, str_actors_f, str_actors_t, str_actors_r, str_aggressors_p, str_aggressors_f, str_aggressors_t, str_aggressors_r, id_win_hand, id_win_hand_lo, id_winner, id_winner_lo, button, card_1, card_2, card_3, card_4, card_5, flg_note, flg_tag, flg_autonote) TO stdout;

execution error backing up files.
-------------------
Optional Files
-------------------
File: C:\Users\Raphael Roquim\AppData\Local\PokerTracker 4\Data/*.*
File: C:\Users\Raphael Roquim\AppData\Local\PokerTracker 4\Config/*.*
Remove Temp Files...OK
Remove Temp Folders
Error Removing Temp Databases Files...Error
-------------------
Errors were detected during backup.



And the backup file that was created has just 220kb of size... Definitely something went wrong....
I had 60gb free before the process, now I have 20gb... WTF?

[Roquim]

I found the file on appdata/temp and deleted it...
Now, i am trying again... Waiting for support plzzz lol tyty

[Roquim]

2nd chance, same error...

[Flag_Hippo]

How big is the database? If you click 'Database -> Database Management' in PokerTracker 4 what version of PostgreSQL is displayed there?

[Roquim]

57gb and postgre 9.3.9

[Flag_Hippo]

This looks like you have some database corruption in the tourney_hand_summary table. If you know SQL you could find out which row is causing the issue although the issue may not necessarily be in one specific place. Do you have a recent database backup you could revert to before reimporting your newest hands?

[Roquim]

No, I dont have any backup...What u recomend? i am thinking in start a new one fresh db...

where can i run the pg_dump? in the pgadmin tool? how? ty

[Flag_Hippo]

You can backup a database in PGAdmin however this process is automated for you when backing up via PokerTracker 4 and unless the corruption is fixed then the pg_dump will probably still fail even if you do it outside of PokerTracker 4. Your welcome to try but I'd suggest creating a new database and importing the hands you want to keep there. By default PokerTracker 4 moves your processed hand histories to your \PokerTracker 4\Processed folder which you can access via the 'File -> Open User Data Folder' option. If you do not have all your original hand history files on then you can export them from the current database and don't forget to import your player/hand notes if you have them (Database -> Notes). Also if you have a number of tournaments with manually entered results then exporting those tournaments will create summary files containing the manual results so they can be imported into a new database.

[Roquim]

its a fucking hard work import all the hands again... omg...

[Roquim]

guys, quick question

Do I need to uninstal the PT online to free up the slot KEY? ty