Page 1 of 1

PG version and moving DB

PostPosted: Thu Feb 16, 2012 3:36 am
by erosbandi
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

Re: PG version and moving DB

PostPosted: Thu Feb 16, 2012 4:51 am
by WhiteRider
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.

Re: PG version and moving DB

PostPosted: Thu Feb 16, 2012 5:51 am
by erosbandi
Thanks for the quick reply! I will follow your instructions.

highfalutin