Thread: Is it advisable to pg_upgrade directly from 9.0 to 9.3?
Hello,
How advisable or well known is it to take a 9.0 era db directly to 9.3 using the latest pg_upgrade binary?
I imagine that the upgrade path between adjacent major versions is more battle tested, but we have several dbs that we would like to bring up to date without meandering through ever major version along the way.
Cheers,
Greg
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)
On Wed, Nov 6, 2013 at 7:06 AM, Greg Burek <gb@heroku.com> wrote:
Hello,How advisable or well known is it to take a 9.0 era db directly to 9.3 using the latest pg_upgrade binary?I imagine that the upgrade path between adjacent major versions is more battle tested, but we have several dbs that we would like to bring up to date without meandering through ever major version along the way.Cheers,Greg
On 11/06/2013 01:06 AM, Greg Burek wrote: > Hello, > How advisable or well known is it to take a 9.0 era db directly to 9.3 > using the latest pg_upgrade binary? Sure. I have done it all the way back to 8.3 (with 9.2). You should of course test as pg_upgrade is a tool not a perfect solution. IMO, I would upgrade to 9.2 precisely because it is battle tests, 9.3 isn't but it depends on your particular needs. 9.3 has a lot of cool stuff in it. Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579 PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc For my dreams of your image that blossoms a rose in the deeps of my heart. - W.B. Yeats
On Wed, Nov 6, 2013 at 4:36 AM, Leonardo Carneiro <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?
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
Yeah, the things that matters are always on top of the changelog, so it's not much trouble to look after then.
On Thu, Nov 7, 2013 at 9:00 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi Greg,
I just wanted to know if you were able successfully upgrading from 9.0 to 9.3.
I have been doing this upgrading this past week, but always ended up with unsuccessful upgrade.
It will be great if you can share you knowledge on this.
Thanks!
-Laurent
On Thu, Nov 7, 2013 at 2:07 PM, Greg Burek <gb@heroku.com> wrote:
On Wed, Nov 6, 2013 at 4:36 AM, Leonardo Carneiro <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?
On Thu, Dec 19, 2013 at 10:07 PM, Laurentius Purba <lpurba@sproutloud.com> wrote: > Hi Greg, > > I just wanted to know if you were able successfully upgrading from 9.0 to > 9.3. > > I have been doing this upgrading this past week, but always ended up with > unsuccessful upgrade. > > It will be great if you can share you knowledge on this. It would be even better if you use this thread to report the problems you are seeing, such as someone could help you going through this upgrade process. Regards, -- Michael
Hi Michael,
Sorry about that.
Anyway, my colleague just sent out a similar question to this mailing list right after I sent mine. The subject title is "pg_upgrade & tablespaces".
If you can help us from my colleague's email, I really appreciate.
Thanks!
-Laurent
-Laurent
On Fri, Dec 20, 2013 at 1:05 AM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Thu, Dec 19, 2013 at 10:07 PM, Laurentius PurbaIt would be even better if you use this thread to report the problems
<lpurba@sproutloud.com> wrote:
> Hi Greg,
>
> I just wanted to know if you were able successfully upgrading from 9.0 to
> 9.3.
>
> I have been doing this upgrading this past week, but always ended up with
> unsuccessful upgrade.
>
> It will be great if you can share you knowledge on this.
you are seeing, such as someone could help you going through this
upgrade process.
Regards,
--
Michael