I'm in the enviable position of migrating postgres database from the current machine to a dedicated server platform. I would also like to take the opportunity to upgrade the version of postgres to current. Does anyone know of any gotchas in this process that I should be especially looking out for?
Cheers, Steve