PDA

View Full Version : database problems



blackaces24
10-30-2008, 12:25 PM
hi all,

I installed holdemmanager on a new computer. somehow some of my old hand histories got lost and now the database was incomplete. so i created a backup file of the old database and restored it on the new computer with pgadmin.(tried a million times before it actually worked)
now the new (old) database has got all the hands inside but it has somehow multiplied the hands. i found the same hands up to 32 times after a quick look. how can i delete the double, triple ... hand histories quickly?

could you help me please?

morny
10-30-2008, 01:23 PM
Sounds like everytime you restored it replicated the hands so the best thing to do is uninstall PostgreSQL, delete the C:\PostgreSQL folder and reinstall PostgreSQL and then restore the database once

blackaces24
10-30-2008, 03:10 PM
i exported all hands and reimported them afterwards to a new database. the dublicate hands were sorted out. seems to work now.