90% of all hands fail on import after db move

[starf]

so i moved my db from postgresql 8.2 to 8.3 like this:
1) backup db
2) uninstall postgresql 8.2/install postgresql 8.3
3) open hm and let hm create a new empty db
4) restore db

everything seemed to have worked flawless but now when i try to import NEW files, 90% gives import errors, is there a log somewhere?
maybe i shouldn't have done point 3?
starting to freak out, please help...

[fabio]

I would suggest exporting all your hands, creating a new database and reimport them.

[starf]

obviously i exported all my hands & copied my original 8.2 data directory before i did anything but i'd hate to revert back to 8.2 or re-import 2mil hands

[fabio]

you dont need to revert back to 8.2. Just create a new db, import all hands. It's the easiest way. :)

[starf]

i think it's the most time-consuming way, and being a system administrator i don't like it :)

[starf]

ok so i think i got this fixed

removed the db, created an empty db and restored the content from the file (didn't let hm make it)

2 remarks (if someone else encounters the same problem)
- after that my pc was slow as hell but i let postgresql do a reindex/force and now i'm importing at +-45h/s again instead of 5h/s
- db size decreased from 16GB to 7GB (i vacuum/analysed the old db alot)

[Rvg72]

I'm glad you got it figured out and those are great improvements. There is a way to do it through command line by using pg_dumpall and then restoring the file which is version safe. I'll be integrating that into the dbcontrolpanel in 1.06.03