PDA

View Full Version : New postgreSQL



Winged Guy
03-18-2010, 02:15 PM
Hi guys)

I'm moving to the new PC. I want to install the latest postgres (i think 8.4) on the new PC. I have 8.3 version on my old PC.

It is said in FAQ, that transferring database from old postgres to a newer one may cause problems.

I would like to know what is better and why: to backup database and restore it with newer postgres, or to create new database with new postgres and import several millions of hands (assuming it will take a lot of time)?

fozzy71
03-18-2010, 10:36 PM
The latter. I would not attempt a backup in 8.3 and restore into 8.4. You are always best off to backup everything manually and import it new. If you have millions of hands I suggest you organize your archived/original hands you want to import into smaller groups. Then you can hopefully import a group (perhaps 500k - 1million hands) over night. Then you can vacuum your DB and use your PC like normal the next day and/or play poker. Then before you go to bed you import the next group. Rinse and repeat.