[galaxy-dev] Upgrading postgres version

Hello, We'd like to migrate from postgres 8.4 installed system wide through Ubunutu package manager to postres version 9 installed from source. Is there a smooth and easy route for this or is it the manual database dump/migrate pain that I think it will be? Thanks, Jim