PDA

View Full Version : Upgrade to PostgresQL 8.4 = what's the procedure?



209
10-24-2009, 07:42 AM
Hi there

Searched hard but struggled find a definitive procedure for upgrading to the latest version.

Really grateful if you could guide me to where I can find this info.

Thanks in anticipation.

Lunatic973
10-24-2009, 07:50 AM
http://www.holdemmanager.net/forum/showthread.php?t=12925&page=26

netsrak
10-25-2009, 06:51 AM
Don't touch a running system. Postgresql 8.4 will not do anything better if you have 8.3 up and running.

209
10-25-2009, 09:11 AM
Don't touch a running system. Postgresql 8.4 will not do anything better if you have 8.3 up and running.

thank you.

julian
10-25-2009, 10:34 AM
Don't touch a running system. Postgresql 8.4 will not do anything better if you have 8.3 up and running.

I'm using an older version of Postgresql (8.2.14) and I'm not aware of any trouble with it.

I don't have to manually vacuum databases as I did with the newer versions.

fozzy71
10-25-2009, 02:34 PM
I'm using an older version of Postgresql (8.2.14) and I'm not aware of any trouble with it.

I don't have to manually vacuum databases as I did with the newer versions.

Just because it doesnt ask you to vacuum, doesnt mean that you should never vacuum. I recommend you vacuum every 30-50k hands, and defrag, (with postgres service stopped).

Lunatic973
10-25-2009, 08:28 PM
Don't touch a running system. Postgresql 8.4 will not do anything better if you have 8.3 up and running.

My 8.3 kept bogging down my computer and was very laggy with only 100,000 hands. Even after performing vacuum, defragging hard drive, removing unused programs, etc, it was still laggy. Once I updated to 8.4 it runs a lot better. Updating really is no big deal. Back up your database, uninstall 8.3, install 8.4, create a new database on 8.4 and import all your hands from the file you backed them up to. Whole thing takes about 1 - 1/2 hours depending on amount of hands you have.

julian
10-26-2009, 11:16 AM
Just because it doesnt ask you to vacuum, doesnt mean that you should never vacuum. I recommend you vacuum every 30-50k hands, and defrag, (with postgres service stopped).

No sorry, what I meant was the option to do a vacuum from the Holdem Manager menu works, so I don't have to open Pga admin as I did with the later vesion of Postgresql :)

lystor
05-15-2010, 05:31 AM
Upgrading PostgreSQL 8.1 to 8.4 on CentOS 5.5 (http://blog.lystor.org.ua/2010/05/upgrading-postgresql-81-to-84-centos-55.html)