Backup of playernotes buggy ?

[Guenni]

Hey there,
just wanted to make a quick backup of all my playernotes.
Went to DB Manager > Backup, Checked only the player notes and skip database boxes and clicked start backup.
after ~2hours of waiting nothing happens. no file in the supposed backup directory or sth else.

Log says:

05:54.371 [Worker:PokerManager.set_CurrentExclusiveTask] Current background task = Backup
05:54.485 [Worker:PostgresqlDatabase.Open] Finished Opening connection with SERVER=127.0.0.1;PORT=5432;UID=postgres;PWD=xxx;DA TABASE=postgres;POOLING=False; in 114 ms
05:54.499 [Worker:PostgresqlDatabase.GetAllPlayerNotes] Getting all notes for players
05:54.500 [Worker:PostgresqlDatabase.Open] Finished Opening connection with SERVER=127.0.0.1;PORT=5432;UID=postgres;PWD=xxx;DA TABASE=HM2;POOLING=True;MINPOOLSIZE=10;MAXPOOLSIZE =50; in 1 ms
05:55.000 [Worker:PostgresqlDatabase.GetAllPlayerNotes] 2045 Notes retrieved for all players
06:03.629 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
06:28.611 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
06:38.620 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
06:48.626 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
06:58.635 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
07:08.635 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
07:18.651 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
07:28.665 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
07:38.670 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
07:48.680 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
07:58.689 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
08:08.695 [Main:StatusBarViewModel.nc_handProcessingStopped] starts
[....]

Am i missing something ? Shouldnt be usual that it takes ~ 2hours for >2000 notes to backup, right ?
any chance i am going to save the notes without using the buggy backup thing ?

[Patvs]

Which PostgreSQL version are you using?
Were these 2000 notes created in HM2, or made in HM1--> where you imported the entire HM1 database into HM2?

[Guenni]

Which PostgreSQL version are you using?

9.0

Were these 2000 notes created in HM2, or made in HM1--> where you imported the entire HM1 database into HM2?

Database was imported from HM1 2 month ago, so i'd guess ~100 notes will be new.

Actually i backuped overnight again and now it is finished but as i said, i only wanted to backup player notes and now the backup file is 3.5gig (i have 17mio hands-database)...

[Patvs]

You'll have to use PostgreSQL 8.4 to be able to use the backup/restore utility.

So in HM1, export your notes.
Then install PostgreSQL 8.4.
Reimport your hands (in HM1) into a NEW database---> then import the notes.


Finally, import the SQL 8.4 database into a new HM2 database. And you'll be able to backup the notes.