Page 1 of 1

Upgrading PostgreSQL help...

PostPosted: Thu Apr 17, 2008 2:13 pm
by LaidBackAl
Anyone any good with PostgreSQL??

I am running version 8.2 on my computer for PokerTracker, and I figured since I am moving to PT 3 that I should probably also upgrade my SQL to the latest and greatest as well, which is ver. 8.3.1. I am extremely computer literate but not very database literate at all. When I started looking into this, from what I can tell, you need a PhD in rocket science to figure out the helll they are talking about. I don't really understand why they can't develop an executable to upgrade, but the process is quite complex even to me and I have been working with systems all my life. Of course since it is open source there is nobody to ask questions directly to.

Is there any easier way to do this???

Why couldn't I just backup the databases for Poker Tracker out of version 8.2, uninstall PostgreSQL version 8.2 completely from my system, Reinstall a fresh copy of version 8.3.1, restore the databases, and connect the new version of PokerTracker to the restored databases??

Any help would be greatly appreciated!!

Michael

Re: Upgrading PostgreSQL help...

PostPosted: Thu Apr 17, 2008 4:29 pm
by APerfect10
Why couldn't I just backup the databases for Poker Tracker out of version 8.2, uninstall PostgreSQL version 8.2 completely from my system, Reinstall a fresh copy of version 8.3.1, restore the databases, and connect the new version of PokerTracker to the restored databases??


That is exactly the process that you should do. What problems are you experiencing?

Best regards,

Derek

Re: Upgrading PostgreSQL help...

PostPosted: Fri Apr 18, 2008 5:45 pm
by ORAG
Hmmm, I've been running PT3 on Postgres 8.2 for a few weeks w/o problem, I guess that's a bad thing?

Re: Upgrading PostgreSQL help...

PostPosted: Fri Apr 18, 2008 7:24 pm
by APerfect10
ORAG wrote:Hmmm, I've been running PT3 on Postgres 8.2 for a few weeks w/o problem, I guess that's a bad thing?


That's fine. Some Vista machines (without SP1) are unable to even run 8.3. I would guesstimate there is a 10-15% performance boost from 8.2.7 -> 8.3.1. It's not a huge issue...

Best regards,

Derek

Re: Upgrading PostgreSQL help...

PostPosted: Sat Apr 19, 2008 9:18 am
by WhiteRider
Please be aware that if you update to 8.3.1 and are still using PT2 and PAH, the cache functionality in PAH does not work [for me at least] and is not officially supported.

Re: Upgrading PostgreSQL help...

PostPosted: Sat Apr 19, 2008 12:19 pm
by APerfect10
WhiteRider wrote:Please be aware that if you update to 8.3.1 and are still using PT2 and PAH, the cache functionality in PAH does not work [for me at least] and is not officially supported.


For everyone...

Re: Upgrading PostgreSQL help...

PostPosted: Sat Apr 19, 2008 5:50 pm
by lakeguy1
Just to make this all explicit.

I have a PC with XP Pro installed, sp2, up to date. I do not want to install vista.
I have installed Poker Tracker Holdem 2 just recently, and installed the 4/18 patches just now.
I also have installed PAHUD and am working on using it. I have no data worth saving as yet.

My database is PostgreSQL 8.3.1. I read above in this thread that cache will not work properly for PAHUD with this version.

So are you recommending that I uninstall 8.3.1 and reinstall 8.2?
Thank you,
paul taubr

Re: Upgrading PostgreSQL help...

PostPosted: Sun Apr 20, 2008 12:26 am
by APerfect10
So are you recommending that I uninstall 8.3.1 and reinstall 8.2?


If you want to use the PokerAce Hud cache, yes you will need to revert back to 8.2.7 which is the latest version supported...

To do this, simply export your database in PT2. Completely remove PostgreSQL 8.3 then install 8.2.7 and import the database via PT2.

Best regards,

Derek