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:
Show quoted text
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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:
Show quoted text
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:
Show quoted text
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
On Fri, Dec 20, 2013 at 1:05 AM, Michael Paquier
<michael.paquier@gmail.com>wrote:
Show quoted text
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