PG version and moving DB

General discussion of PokerTracker 3.

Moderator: Moderators

PG version and moving DB

Postby erosbandi » Thu Feb 16, 2012 3:36 am

My questions would be the followings, any help would be appreciated.
I have two computers. First one is a notebook (PT3 installed and configured with custom stats, etc.)
and the second one is a powerfull desktop computer (no PT3 installation yet).
I want to import a big number of hands (6-7 millions) in the desktop machine because of the speed.
Than I want to backup this DB and move to the notebook.

So my first question would be that I have several custom statistics in my notebook is it enough if I
export these stats from notebook and import to the desktop machine before importing?
With this procedure will be DB problems avoided? I mean no custom stat value in my HUD during play
using the moved new DB?

My second question would be that on my notebook 8.4.1 PG is installed but as far as I know PT3 installs
8.3.9 are they 100% compatible? I tried to find 8.4.1 version on PostGres site but versions from 8.4.6
are available.
Any help would be appreciated!
Thx
Bandi
erosbandi
 
Posts: 80
Joined: Mon Mar 23, 2009 11:53 am

Re: PG version and moving DB

Postby WhiteRider » Thu Feb 16, 2012 4:51 am

You can transfer information (custom stats, databases, etc) between PT3 installations using backup/restore. Check out the Tutorial: Backup and Restore for more information.

Different major PostgreSQL versions (i.e. 8.3 vs 8.4) are not directly compatible, but the backup/restore mechanism should work fine.
When you set up your new desktop you may prefer to install 9.0.6, especially if you will be running 64-bit Windows as that has a 64-bit version which will give you a bit of a performance improvement. (Note: don't go for 9.1 - it is still pretty new and we do not yet support it)
Either way, you should install the latest version of whichever major version you decide to use.

I would suggest that you transfer your custom stats to your desktop before you do the import, using backup/restore.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: PG version and moving DB

Postby erosbandi » Thu Feb 16, 2012 5:51 am

Thanks for the quick reply! I will follow your instructions.
erosbandi
 
Posts: 80
Joined: Mon Mar 23, 2009 11:53 am


Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 42 guests

cron
highfalutin