Upgrading PostgreSQL

[airscape]

Rush poker is lagging when PT3 is running, without it its running perfectly fine. Im using PostgresQL 8.2 wich is several years old.

What are my steps to upgrade successfully, i guess i need to take backup of my database and reinstall everything?

I mean i read stuff like karadas post in this: viewtopic.php?f=16&t=34344&p=168877&hilit=upgrade+postgresql#p168877 and it seems upgrading postgresql is something proes does and there is internal jargong going on or whatever with several different options.

example:

Also, when you upgrade PostgreSQL, if you use pg_dump to dump the databases from the old version, then pg_restore to get them into the new version, you won't need to reimport anything.

Yeah should i use pg_dump?

also here is a copy of my thread, viewtopic.php?f=17&t=34073&p=167421&hilit=upgrade+postgresql#p167421

and should i do this stuff? viewtopic.php?f=45&t=10393 ... i just want a PT3 that runs smoothly thats all, i need no options to evaluate.

IF you have another solution that may fix my lag im very thankful btw, but i have to guess postgresql beeing so old is the most likely reason? Im so not keen to do this backup and upgrade thingy..

[kraada]

That user had a special setup - he wasn't just running normal Windows.

Upgrading for you shouldn't be that bad. Backup any and all databases in PT3 using the Backup and Restore functionality.

You don't even actually need to uninstall 8.2 - just install the new version you want to upgrade to (at this point, 9.0 seems pretty solid so you can go there safely). When installing 9.0 (from this link), it'll prompt you what port to pick - pick something that isn't 5432 - that's where 8.2 is right now. 5490 works well (and the 90 reminds you that you're using it for 9.0!).

Once it's installed, restore your backed up database to the 9.0 version, then you can proceed from there. Once you're certain all data has been migrated properly you can uninstall 8.2 at your leisure.

[airscape]

Thank you that was pretty concrete and what i needed to get the guts, i think im gonna actually do this and newest version seems smart

How long will the backup phase, and installing postgresql 9 take? If both is in the several hours area i need to schedule a little bit

Also just in case somebody knows, the most annoying lag comes from the mouse "lagging" when draggin the mouse between different tables when i have FTcash script enabled, wich "highlights" the table i drag the mouse over.. this isnt PT3 relevant i guess thou:P But i dunno if it is a vista problem/hardware, suggests there is something more wrong than my PT3 and postgresql

[kraada]

8.2 to any newer version will show considerable improvements. Whether it'll be enough, I'm not sure, but it will help.

The entire process shouldn't take more than an hour unless you have some very large databases.

[WhiteRider]

Upgrading for you shouldn't be that bad. Backup any and all databases in PT3 using the Backup and Restore functionality.

Please be aware that the built-in backup mechanism may not work correctly with PostgreSQL 8.2, so do not delete anything before you have restored into the new version.

If you have problems with the backup you can do it outside PT3 as described in the Database / PostgreSQL FAQ.

[airscape]

About 600k hands i think.. thanks for that whiterider i hope it works the normal way thou:P

[jdx_]

8.2 to any newer version will show considerable improvements. Whether it'll be enough, I'm not sure, but it will help.

The entire process shouldn't take more than an hour unless you have some very large databases.

I upgraded today from 8.2.7 to 9.0.4 and HUD's performance improvement is HUGE. I'm very pleased because earlier HUD worked horribly slow while 4-6 tabling on Party.

[kraada]

8.2.x to anything 8.3 or higher will produce pretty big results. I'm glad to hear everything is working well for you now

[Sipski]

Also wanted to upgrade my Postgres (8.3.4) to a new 9.0 version. I followed all these steps

That user had a special setup - he wasn't just running normal Windows.

You don't even actually need to uninstall 8.2 - just install the new version you want to upgrade to (at this point, 9.0 seems pretty solid so you can go there safely). When installing 9.0 (from this link), it'll prompt you what port to pick - pick something that isn't 5432 - that's where 8.2 is right now. 5490 works well (and the 90 reminds you that you're using it for 9.0!).

But I didnt understand how to restore a database under 9.0 version, because PT3 at database managment tab still show postgresSQl 8.3.4. When i open pgAdmin tool there are showen that i got 2 servers PostgresSQl 9.0(localhost:5490) and PostgresSQl database server(localhost:5432).
I tried to find an answer but without any succes. Can u help me, what i need to do now? Should i back up restore my database manualy at Pgadmin and then add it to Pt3 database list?

[kraada]

Restoring manually via PGAdmin and then adding it to PT3 (via the blue Browse link with the proper port filled in) is probably the easiest if you understand that method.