Обсуждение: upgrade from 8.3 to 8.4
| I am going to upgrade our PostgresSQL server from 8.3 to 8.4. Is there any application code change required? I did some google searches and can't find any. thanks, Claire |
Your question is impossible to answer.
Look here (and in the release docs for the point releases): http://www.postgresql.org/docs/8.4/static/release-8-4.html and then ask more specific questions if you are still concerned.
Google is a good tool if you know how to write a good query (did you try “postgresql 8.4 release notes”) but you are also advised to browse the PostgreSQL site (namely the section on the homepage that provides links to the notes for the most recent four releases).
It is also recommended that you TEST your application against the new database version in a non-production environment.
And the implicit question of whether it is worth the effort to upgrade to 8.4 (or higher…) also cannot be answered by someone who has never seen your code.
Backward compatibility is not guaranteed between versions BUT it is not always that case that you are actually using the things that break.
David J.
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Claire Chang
Sent: Monday, August 08, 2011 7:12 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] upgrade from 8.3 to 8.4
I am going to upgrade our PostgresSQL server from 8.3 to 8.4. Is there any application code change required? I did some google searches and can't find any.
thanks, Claire |
On 08/08/11 4:11 PM, Claire Chang wrote: > I am going to upgrade our PostgresSQL server from 8.3 to 8.4. Is there > any application code change required? I did some google searches and > can't find any. > to what David already said, I will add this observation... 8.4 is pickier about implied type conversions... if you have code that assumes it can mix types like text and numeric operations, it may require adding some explicit type casting, or it will throw errors. thats the only major thing I've seen that impacts applications. I assume you know that you need to do a pg_dumpall of your 8.3 data then load it onto your new 8.4 database cluster, right? -- john r pierce N 37, W 122 santa cruz ca mid-left coast