There is an on disk incompatibility between 8.2 and 8.3 which means the only way you can upgrade is to dump your 8.2 cluster (pg_dumpall), create a new 8.3 cluster (initdb), and restore the data (pg_restore). It's more of a 'migration', rather than an 'upgrade'. Sun's pg_upgrade.sh cannot help you here I'm afraid (it can only handle 8.1 to 8.2).
I wouldn't suggest migrating from 32 bit to 64 bit without first performing a thorough test (which of course is easy to do with the migration method I describe above). There shouldn't be any problems with your data, but you might find you have to increase shared memory settings, swap space, process ulimits, etc. to get the 64 bit database processes to start & run properly. You may also notice a small change in performance - Some 64 bit apps run faster on AMD, and some run slower on SPARC, but this is not consistent or guaranteed. Poorni Anneshwari wrote: > Jim...Thanks for your reply. The site is indeed very useful. Just one more > question. When upgrading from 32 bits to 64 bit version, do you know what are > the problems that one might encounter? > Any help on this issue would be greatly appreciated. > Thanks! -- Jim Gates Sun Microsystems Nashua, NH, USA http://sun.com/postgresql
