Re: upgrade

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: William Bruton <drc(at)spidr(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: upgrade
Date: 2011-02-03 06:43:01
Message-ID: AANLkTimqS-qCruZgZLfsmWw-wgG5E_=j35vHOJw1XmJS@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Feb 2, 2011 at 12:08 PM, William Bruton <drc(at)spidr(dot)com> wrote:
> How do I know which version to upgrade to from 8.1.4?

you should first update to 8.1.latest so you've got all the bug fixes
available. It's pretty close to painless, and unless the release
notes between 8.1.5 and 8.1.latest say you need to do anything out of
the ordinary, it's just a software update, no admin work to do.

Upgrading to a later version I'd go for 8.2 or 9.0. 8.3 removed a lot
of explicit casts that some (broken really) programs need to work
right. So going to 8.3 or beyond you're making a commitment to
hunting down such code and fixing it.

9.0 is WORLDS ahead of 8.2 though, and well worth the effort, if
needed, to move to.

In response to

  • upgrade at 2011-02-02 19:08:19 from William Bruton

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2011-02-03 07:13:17 Re: isn't "insert into where not exists" atomic?
Previous Message Scott Marlowe 2011-02-03 05:34:47 Re: Why does my DB size differ between Production and DR? (Postgres 8.4)