Thread: Upgrading from 9.0->9.1 Ubuntu Best Practices
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! -- View this message in context: http://postgresql.1045698.n5.nabble.com/Upgrading-from-9-0-9-1-Ubuntu-Best-Practices-tp4809232p4809232.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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.