Upgrading PostgreSQL help...

[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

[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

[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?

[APerfect10]

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

[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.

[APerfect10]

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...

[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

[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