Questions about updating from 8.2 to 8.3

[DerekG]

I remember being told I can install 8.3 along side 8.2 and they should work together.

1) Any potential problems/headaches if I pull HUD data from both an 8.2 and 8.3 db?

2) Will new databases automatically be created as 8.3 or is there something I need to check or change since I'll be keeping 8.2 around for a month or so?

3) Will I be able to restore one of my saved 8.2 databases from a previous pg_dump into 8.3? (If not, I guess I better keep 8.2 installed.)

4) I currently have 2 servers listed in PGAdmin (both 8.2). The only difference between the two is one lists Maintenance Database as postgres, the other as template1. I remember reading somewhere that this was changed during one of the 8.2.x updates. Also, Restore Environment is No on one server, Yes on another. I'm not sure what this does. My question is, is it safe or helpful in any way to delete/drop one of these before installing v8.3?

Thank you.

[keggler]

i have no idea if pt3 hud will accept multiple dbs from different versions; and i guess if you use the native 8. 3 pg command line interfaces to create your new dbs,they will be created in 8.3 format - but which db will pt be auto importing to? 8.3 i guess, so move your 8.2 data to 8.3, and then just let pt update this - keep your 8.2 database just in case... also keep your processed hh's (this is good practice in any case),so if it all goes belly-up, you have a back-stop to re-populate;

but speaking purely from a postgres perspective:

probably best if you run them on different ports... then you can run something like: pg_dumpall -p 5432 | psql -d postgres -p 6543 to transfer your data.

hth


susan

[DerekG]

Yeah, I'll definitely use a different port# when I install it, thanks. Never tried that pg_dumpall command before, I'll experiment with it. Do you happen to know if having these two different servers affects performance in any way? Can I drop one?

[tarix]

Do you happen to know if having these two different servers affects performance in any way? Can I drop one?

There will be a small amount of overhead since you are running two copies of pg_ctrl.exe and you are accessing two completely different sets of files. You could probably measure it, but I doubt you could "feel" it.

In any case 8.3 is supposed to have speed improvements over 8.2 so it is probably worth the effort of upgrading and migrating everything to 8.3.

[WhiteRider]

Just bear in mind the PT2/PAH complication if you still use them.

It is possible to use PT2 with postgres 8.3,
but the PAH cache does not work with 8.3.

[DerekG]

two completely different sets of files

That's the weird thing. It's two different 8.2 servers accessing the same files and databases. Not sure why, it's all over my head but I assumed it had something to do with the Maintenance Database namechange during one of the 8.2.x updates. Running the upgrade.bat script never works for me, I always have to do a complete uninstall/reinstall in order to upgrade.

Whiterider, thanks for the heads-up.