Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?
Date
Msg-id 527C1B91.4090204@gmail.com
Whole thread Raw
In response to Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?  (Greg Burek <gb@heroku.com>)
Responses Re: Is it advisable to pg_upgrade directly from 9.0 to 9.3?
List pgsql-general
On 11/07/2013 11:07 AM, Greg Burek wrote:
> On Wed, Nov 6, 2013 at 4:36 AM, Leonardo Carneiro
> <chesterman86@gmail.com <mailto:chesterman86@gmail.com>> wrote:
>
>     I don't think that there will be too much trouble, as long as you
>     follow every changelog tip (9.0->9.1, 9.1->9.2 and 9.2->9.3)
>
>
> What if we don't follow the changelog tip? In this case, we have only
> the 9.0 and 9.3 binaries installed and pg_upgrade directly to 9.3. Does
> that cause fear?

Not so much fear as concern. One of my rules is that the good will take
care of itself it is the bad you have to plan for. In this case it is
not the nine changes that do not impact your code but the one that does.
When going through the change logs the incompatibilities are listed at
the top under the  Migration to Version 9.* header. It does not take to
long to double check. If you want to save time just look at the major
version changes, i.e 9.X versus 9.X.x as incompatibilities are allowed
in major version changes. Not that they do not happen in minor releases,
but that is generally done to fix a security/major bug and I do not
recall any in the range you are looking at.

--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Curious question about physical files to store database
Next
From: Victor Hooi
Date:
Subject: Breaking up a PostgreSQL COPY command into chunks?