Re: upgrade from 8.3 to 8.4 - Mailing list pgsql-general

From David Johnston
Subject Re: upgrade from 8.3 to 8.4
Date
Msg-id 013601cc5627$97349260$c59db720$@yahoo.com
Whole thread Raw
In response to upgrade from 8.3 to 8.4  (Claire Chang <yenhsiac@yahoo.com>)
List pgsql-general

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

 

pgsql-general by date:

Previous
From: Claire Chang
Date:
Subject: upgrade from 8.3 to 8.4
Next
From: Paul M Foster
Date:
Subject: Re: Update with ORDER BY and LIMIT