Re: [GENERAL] Which postgresql should i choose to migrate from 8.3 ? 8.4 or 9.1?
On Tue, Aug 28, 2012 at 9:52 AM, Ing.Edmundo.Robles.Lopez < erob...@sensacd.com.mx> wrote: > Hi! > We are using postgresql 8.3 in my work, and the need to migrate to a newer > version became urgent :) > > I've been reading the release notes for versions 8.4 and 9.1, but is not > clear to me which problems I can have with version 8.4 or 9.1 from a dump > 8.3 > Just as a note, you will have far fewer problems if you can use the newer version's dump programs against 8.3 than if you try to dump with 8.3 tools and restore in later versions. > > My boss thinks we would have fewer problems if we use the version 8.4, I > believe that it is best to have version 9.1, and the number of problems > will be the same as in version 8.4 > I think the sorts of problems you have are likely to be different. 8.4 is likely to be the easiest migration, it is true. I can tell you as far as LedgerSMB goes, we had the most trouble with 8.3 and 9.1 when they came out because of changes that specifically affected us in those releases (the extension system was the big one in 9.1). Your tradeoff is basically this: The more major versions you move up, the more likely you are to have immediate issues, but you can buy more time between major version upgrades and the backwards-compatibility-breaking improvements usually are significant improvements, so you may have more work in the migration but then you have a better ability to be cautious about moving forward. > > > In favor of version 9.1 is that it will be supported until 2016. > > > What is the structural difference or what was the reason to have a version > 9 and version 8? > > To be honest, you can't put a lot of stock in whether it was named 8.5 or 9.0. Every application is unique. Every major version (8.4, 9.0, 9.1, 9.2) will introduce backwards-incompatible behavior and much of this is actually an improvement once you get the specific problems you have fixed. As I say the move from 8.2 to 8.3 hit us pretty hard because of the casting changes. 9.0 didn't cause any problems for us at all (neither did 8.4). 9.1 caused us to have a number of installation issues since we depend on contrib stuff that took a while to get sorted out but would have been tolerable if we were not distributing software. > > > > Please, could you help to give peace of mind to my boss and make sure that > the version we choose to be as smooth as possible compatible with version > 8.3? > > indeed to restore the dump of the 83 in 9.1 had a bug in UTF-8, will I > have the same problem with the 8.4??? > Always use the new tools to back up the old db during migration. So if moving from 8.3 to 9.1, use the 9.1's pg_dump. Otherwise you can expect problems. > > What will be the problems you have had to migrate from version 8.x to the > 8.4 or 9.1??? > > is it a good idea migrate to 9.1 rather than 8.4? > If it were my organization I'd start doing this on a separate server for testing purposes (use the pg_dump from the new server to back up the data from the old server). Then I'd run tests and see what the gaps were. Then depending on urgency, I would ideally choose to fix those problems and then migrate. However, if it is particularly urgent, I might scale back to 8.4 and try again. > Perhaps, it would be a good idea to have a page on the postgresql site > which is titled: How to convince my boss to install latest version. ;) > Best Wishes, Chris Travers
Re: [GENERAL] Which postgresql should i choose to migrate from 8.3 ? 8.4 or 9.1?
On 29/08/12 04:52, Ing.Edmundo.Robles.Lopez wrote: Hi! We are using postgresql 8.3 in my work, and the need to migrate to a newer version became urgent :) I've been reading the release notes for versions 8.4 and 9.1, but is not clear to me which problems I can have with version 8.4 or 9.1 from a dump 8.3 My boss thinks we would have fewer problems if we use the version 8.4, I believe that it is best to have version 9.1, and the number of problems will be the same as in version 8.4 In favor of version 9.1 is that it will be supported until 2016. What is the structural difference or what was the reason to have a version 9 and version 8? Please, could you help to give peace of mind to my boss and make sure that the version we choose to be as smooth as possible compatible with version 8.3? indeed to restore the dump of the 83 in 9.1 had a bug in UTF-8, will I have the same problem with the 8.4??? What will be the problems you have had to migrate from version 8.x to the 8.4 or 9.1??? is it a good idea migrate to 9.1 rather than 8.4? Perhaps, it would be a good idea to have a page on the postgresql site which is titled: How to convince my boss to install latest version. ;) Farewell, and thank you for your help. Regards. El contenido de este correo electrónico y sus archivos adjuntos son privados y confidenciales y va dirigido exclusivamente a su destinatario. No se autoriza la utilización, retransmisión, diseminación, o cualquier otro uso de esta información por un receptor o entidades distintas al destinatario. Si recibe este correo sin ser el destinatario se le solicita eliminarlo y hacerlo del conocimiento del emisor. La empresa no se hace responsable de transmisiones o comunicaciones no autorizadas o emitidas por personas ajenas a sus colaboradores utilizando éste medio electrónico. The content of this email and its attached files are private and confidential and intended exclusively for the use of the individual or entity to which they are addressed. The retransmission, dissemination, or any other use of this information other than by the intended recipient is prohibited. If you have received this email in error please delete it and notify the sender. The company cannot be held liable for unauthorized electronic transmissions or communications, nor for those emitted by non-company individuals and entities. Pg 9.2 is out real soon now; but for you, I think going to 9.1 is a better trade-off in risks and benefits. The 9.1 version is far faster and more reliable than 8.4, apart from having extra functionality that may prove very useful. However, as has has been noted elsewhere: there are incompatibilities between the version you are using now and 9.1, so you will need to rigorously check for these. Cheers, Gavin
Re: [GENERAL] Which postgresql should i choose to migrate from 8.3 ? 8.4 or 9.1?
On Tuesday, August 28, 2012 11:52:26 AM Ing.Edmundo.Robles.Lopez wrote: > Please, could you help to give peace of mind to my boss and make sure > that the version we choose to be as smooth as possible compatible with > version 8.3? > All compatibility changes are indicated in the upgrade notes from one version to another. Read them, see if they apply to you. Install 9.1 on a test server. Test it with your data. It's free :) > indeed to restore the dump of the 83 in 9.1 had a bug in UTF-8, will I > have the same problem with the 8.4??? Probably. If you have data in your UTF-8 database that is not valid UTF-8 you will eventually need to clean it up. Also, some of the default config options have changed (in particular bytea encoding options); they were the only issues I ran into when upgrading. But only you know what features your applications use. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Which postgresql should i choose to migrate from 8.3 ? 8.4 or 9.1?
Hi! We are using postgresql 8.3 in my work, and the need to migrate to a newer version became urgent :) I've been reading the release notes for versions 8.4 and 9.1, but is not clear to me which problems I can have with version 8.4 or 9.1 from a dump 8.3 My boss thinks we would have fewer problems if we use the version 8.4, I believe that it is best to have version 9.1, and the number of problems will be the same as in version 8.4 In favor of version 9.1 is that it will be supported until 2016. What is the structural difference or what was the reason to have a version 9 and version 8? Please, could you help to give peace of mind to my boss and make sure that the version we choose to be as smooth as possible compatible with version 8.3? indeed to restore the dump of the 83 in 9.1 had a bug in UTF-8, will I have the same problem with the 8.4??? What will be the problems you have had to migrate from version 8.x to the 8.4 or 9.1??? is it a good idea migrate to 9.1 rather than 8.4? Perhaps, it would be a good idea to have a page on the postgresql site which is titled: How to convince my boss to install latest version. ;) Farewell, and thank you for your help. Regards. El contenido de este correo electrónico y sus archivos adjuntos son privados y confidenciales y va dirigido exclusivamente a su destinatario. No se autoriza la utilización, retransmisión, diseminación, o cualquier otro uso de esta información por un receptor o entidades distintas al destinatario. Si recibe este correo sin ser el destinatario se le solicita eliminarlo y hacerlo del conocimiento del emisor. La empresa no se hace responsable de transmisiones o comunicaciones no autorizadas o emitidas por personas ajenas a sus colaboradores utilizando éste medio electrónico. The content of this email and its attached files are private and confidential and intended exclusively for the use of the individual or entity to which they are addressed. The retransmission, dissemination, or any other use of this information other than by the intended recipient is prohibited. If you have received this email in error please delete it and notify the sender. The company cannot be held liable for unauthorized electronic transmissions or communications, nor for those emitted by non-company individuals and entities. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
