Thread: 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
Attachment
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