PDA

View Full Version : Moving Database



janos
02-05-2011, 07:53 PM
I am trying to move my old postgresql 8.3 database from my old storage to my new SSD-drive. I moved to sql 9 now.
I cant export the whole sql database because I get "doesnt work with omaha" or something, allthough I only care about my MTTs and SNGs.
I cant backup with HEM wiizard because he cant find sql install directory.
I heard pgadminIII doesnt work for different sql version, too.

So I importet the raw HHs from pokerstars, which lack the tourney summaries (eg. how many players an MTT had) and much more.
I exported the tourney summaries in my old database and reimported them, but I still lack lots of informations.

Whats my line?

EDIT: I still have the old storage device with all the data

Patvs
02-06-2011, 12:45 AM
Update to http://www.holdemmanager.com/Downloads/Hm_1.11.06a_Internal.exe

And try the EXPORT again.

Backup & Restore utility currently only supports SQL 8.4
Easiest solution: create a .backup in pgadminIII--> install SQL 8.3 to the SSD. (not 8.4/9.0) so you can restore the .backup.

You could also email PokerStars, and request all your summaries.

janos
02-06-2011, 10:29 AM
Unfortunately Pokerstars cant support me with all the summaries. At least they couldnt when I asked 8 months ago.

"Backup & Restore utility currently only supports SQL 8.4
Easiest solution: create a .backup in pgadminIII--> install SQL 8.3 to the SSD. (not 8.4/9.0) so you can restore the .backup."

What now? You wrote it only supports 8.4. Why should I install 8.3?

Sarek
02-06-2011, 03:44 PM
HM internal utility supports 8.4 only
but PGadmin backup works with any Postgres version - so you can do backup\restore in 8.3