Upgrading from 9.0->9.1 Ubuntu Best Practices

On 16/09/11 12:43, adebarros wrote:

Hi, all, first post on this list.

I'm running Ubuntu 11.04 and have Postgres 9.0 and 8.4 both installed,
although I'm only working with 9.0 at this time for some Django development.

I have added this PPA to my Upgrade Manager:
http://ppa.launchpad.net/pitti/postgresql/ubuntu

The other day I noticed the Upgrade Manager fetched a few 9.1-related files
that were quite small, certainly not the entire 9.1 update.

What is the recommended way for me to:
-- Install 9.1
-- Move my databases to 9.1 from 9.0
-- Remove 9.0 and 8.4 from my system

Thanks!

Since you're on Ubuntu, there's a fairly easy way.

* Install all the 9.1 stuff - server, client, etc.
* Run pg_upgradecluster
* Verify it's all working OK on the new DB.
* Uninstall the 9.0 stuff

Note that the 9.1 server will get installed on a higher port number so
it doesn't conflict with the existing server package.. You'll want to
edit postgresql.conf and change it back to normal once you're done.

Anyone?

On Sat, Sep 17, 2011 at 16:57, Anthony DeBarros <adebarros@gmail.com> wrote:

Anyone?

Didn't you get the reply by Toby Corkindale?

If your database is small (a few gigabytes or less), then
pg_upgradecluster is the easiest way to upgrade on Ubuntu.

Regards,
Marti

Thanks, Toby. For some reason your reply didn't show up while I was looking
at this thread in Google groups. My apologies.

In looking at my system, I see I have 8.4 in there as well from an older
Ubuntu version. I imagine I can remove that once I have 9.1 working fine.

Best,
Anthony

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Upgrading-from-9-0-9-1-Ubuntu-Best-Practices-tp4809232p4813888.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.