PDA

View Full Version : Database problems after restore



Ar3s
03-11-2009, 03:01 AM
I installed postgresl and hm after the format, created a new db and tried to restore my old one, then a popup appeared in the pgadmin after half an hour with some text, after i press ok "would you like to restore again" appears but no succes, the import did seem to work besides that
So when i open hm, i see 11k players but i can not run reports, it just hangs whenever i try something, nothing appears in every tab at all..

morny
03-11-2009, 01:47 PM
Can you create a new database and restore to that, when the restore is finished let me know what it says

Ar3s
03-11-2009, 01:59 PM
Still the same, these are the last lines of the report, i cn send the full if you want:

pg_restore: setting owner and privileges for INDEX specialholecardactions_hero_idx1
pg_restore: setting owner and privileges for INDEX specialholecardactions_hero_idx2
pg_restore: setting owner and privileges for INDEX specialholecardactions_idx1
pg_restore: setting owner and privileges for INDEX specialholecardactions_idx2
pg_restore: setting owner and privileges for INDEX tables_idx1
pg_restore: setting owner and privileges for INDEX tourneydataindex1
pg_restore: setting owner and privileges for INDEX tourneynotes_idx1
pg_restore: setting owner and privileges for INDEX tourneyplayerdataindex1
pg_restore: setting owner and privileges for INDEX tourneyplayerdataindex2
WARNING: errors ignored on restore: 136

Process returned exit code 1.

Ar3s
03-11-2009, 02:43 PM
Same problem with an older abckup, wtf is this............

morny
03-11-2009, 04:29 PM
ok there is something wrong with the backup, try exporting the hands from the database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 then creating a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and reimport the hands into the new database

Ar3s
03-12-2009, 02:23 PM
done, but still the same problem, no reports are showing

morny
03-12-2009, 08:18 PM
email me morny@holdemmanager.net and let me know a suitable time to do the teamviewer session

pawppy
04-25-2009, 07:07 AM
how did u solve this i am getting it too?
'WARNING: errors ignored on restore: 72
Process returned exit code 1.'

morny
04-25-2009, 03:27 PM
try exporting the hands from the database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 then creating a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and reimport the hands into the new database