Обсуждение: 8.38 -> 8.5?

Would anyone know if 8.38 -> 8.5 is anticipated to be ok - or will it
be recommended to
8.38 -> 8.41 -> 8.5 (when available).

Thanks

--
Mike Ellsworth

On Tue, Nov 17, 2009 at 5:35 AM, Mike Ellsworth <younicycle@gmail.com> wrote:
> Would anyone know if 8.38 -> 8.5 is anticipated to be ok - or will it
> be recommended to
> 8.38 -> 8.41 -> 8.5 (when available).

If you dump and reload, I sure 8.3 to 8.5 is 100% safe.  In addition
to this, there is a new feature that may be included into 8.5 known as
In-Place-Upgrade.  Regarding In-Place-Upgrade, I not sure how safe it
will be.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

2009/11/17 Richard Broersma <richard.broersma@gmail.com>:
> On Tue, Nov 17, 2009 at 5:35 AM, Mike Ellsworth <younicycle@gmail.com> wrote:
>> Would anyone know if 8.38 -> 8.5 is anticipated to be ok - or will it
>> be recommended to
>> 8.38 -> 8.41 -> 8.5 (when available).
>
> If you dump and reload, I sure 8.3 to 8.5 is 100% safe.  In addition
> to this, there is a new feature that may be included into 8.5 known as
> In-Place-Upgrade.  Regarding In-Place-Upgrade, I not sure how safe it
> will be.
>
>

I could be wrong (in fact, it's likely), but isn't the
in-place-upgrade done by pg_migrator which only migrates between
neighbouring major versions? (e.g. 8.3 to 8.4, 8.4 to 8.5)

Thom

On Tue, Nov 17, 2009 at 11:49 AM, Thom Brown <thombrown@gmail.com> wrote:
> 2009/11/17 Richard Broersma <richard.broersma@gmail.com>:
>> On Tue, Nov 17, 2009 at 5:35 AM, Mike Ellsworth <younicycle@gmail.com> wrote:
>>> Would anyone know if 8.38 -> 8.5 is anticipated to be ok - or will it
>>> be recommended to
>>> 8.38 -> 8.41 -> 8.5 (when available).
>>
>> If you dump and reload, I sure 8.3 to 8.5 is 100% safe.  In addition
>> to this, there is a new feature that may be included into 8.5 known as
>> In-Place-Upgrade.  Regarding In-Place-Upgrade, I not sure how safe it
>> will be.

>
> I could be wrong (in fact, it's likely), but isn't the
> in-place-upgrade done by pg_migrator which only migrates between
> neighbouring major versions? (e.g. 8.3 to 8.4, 8.4 to 8.5)
>
> Thom
>

Compared to me, both of you guys are in-the-clouds experts, so I am
glad I asked. :-)


--
Mike Ellsworth

On Tue, 2009-11-17 at 08:44 -0800, Richard Broersma wrote:

> If you dump and reload, I sure 8.3 to 8.5 is 100% safe.  In addition

It is too early to say so.
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.org> writes:
> On Tue, 2009-11-17 at 08:44 -0800, Richard Broersma wrote:
>> If you dump and reload, I sure 8.3 to 8.5 is 100% safe.  In addition

> It is too early to say so.

We are certainly going to promise that a dump from 8.3 will load into
8.5.  Whether an application that worked against 8.3 will require any
changes to work with 8.5 is a different question.

As far as the OP's original question goes, it might simplify matters to
first read the 8.4 release notes and update/test the app to work against
8.4, and then repeat for 8.5.  Or maybe it'd be faster to deal with both
sets of compatibility issues at once.  Your call.

            regards, tom lane