| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | "Ing(dot)Edmundo(dot)Robles(dot)Lopez" <erobles(at)sensacd(dot)com(dot)mx> |
| Subject: | Re: Which postgresql should i choose to migrate from 8.3 ? 8.4 or 9.1? |
| Date: | 2012-08-28 17:20:35 |
| Message-ID: | 1645037.4vUaMFMpco@skynet.simkin.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Kaltenbrunner | 2012-08-28 17:49:25 | Re: "Need some information about postgresql products and community" |
| Previous Message | Ing.Edmundo.Robles.Lopez | 2012-08-28 16:52:26 | Which postgresql should i choose to migrate from 8.3 ? 8.4 or 9.1? |