Обсуждение: Upgrade Ubuntu on machine with Postgres 8.3
I'm planning on upgrading Ubuntu 7.10 to 8.04. Is there anything special I need to do to preserve my Postgres 8.3 installation? Should I backup the cluster and reinstall Postgres, or should I just do the Ubuntu upgrade and expect Postgres to keep working? Thanks for you advice, Lee Hachadoorian PhD Student, Geography Program in Earth & Environmental Sciences CUNY Graduate Center
Lee Hachadoorian wrote: > I'm planning on upgrading Ubuntu 7.10 to 8.04. Is there anything > special I need to do to preserve my Postgres 8.3 installation? Should > I backup the cluster and reinstall Postgres, or should I just do the > Ubuntu upgrade and expect Postgres to keep working? > > If you are planning to allow Ubuntu to do the version upgrade, it should do it OK and preserve your data. You should, of course, still backup all important data both PG and other prior to a major upgrade. If you are planning a bare-metal reinstall, you will have to back up everything you want to save including your PG data. If you are using a Debian-based distro like Ubuntu, look at the available Debian-specific utilities (wrappers around PG utilities): pg_createcluster(8), pg_dropcluster(8), pg_lsclusters(1) and pg_wrapper(1). When the Ubuntu version upgrade involves a major PG version upgrade, you may need to use one of the above utilities to migrate your PG data to the new version. Cheers, Steve
Yes I'm going to try the automated Ubuntu version upgrade, but I'm prepared to do a clean install if I have any problems with the upgrade. BTW, where do I find the Debian-specific pg_createcluster, pg_dropcluster, etc. Are they installed as part of Postgres? (I'm not sitting at my Ubuntu machine at the moment, so I can't search the hard drive for them.) Thanks for the info, Lee Hachadoorian PhD Student, Geography Program in Earth & Environmental Sciences CUNY Graduate Center
Lee Hachadoorian wrote: > BTW, where do I find the Debian-specific pg_createcluster, > pg_dropcluster, etc.... > If you (in all likelihood) installed postgresql-common you should have them: http://packages.ubuntu.com/gutsy/all/postgresql-common/filelist Cheers, Steve