PDA

View Full Version : Updating my old PostgreSQL 8.2



ronin222
01-12-2011, 02:43 PM
Hello,

Can someone help with instructions on how i can update my old version of PostgreSQL 8.2 to either 8.3 or 8.4? I am trying to optimize HM.

FYI i run on windows xp.

Thanks.

Patvs
01-13-2011, 04:07 AM
Install SQL 9.0 (or 8.4) to a different port (for example 5433) using the installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

Connect to the new port in dbcontrolpanel.exe (=Database Management) Create a new database--> and run a import from folder on your archive folder.

marceALB
01-21-2011, 04:40 AM
The "import from folder" that you say is done with HM, right? Is there any method to attach 8.3 database to new version? I have a very big database and if i import all the hands I could to take a very long time.

Patvs
01-21-2011, 07:07 AM
If there's nothing wrong with your SQL 8.3 database (no corruption, corrupt index), just stick with 8.3.
Using 8.4/9.0 won't result in faster import speeds.

To update an 8.3 database--> to 8.4 (or 9.0) an advanced SQL migrate script exists.

But I'd just leave on your computer for 24 hours, reimporting the original handhistories.