Re: upgrade from 8.3 to 8.4

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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Claire Chang
Sent: Monday, August 08, 2011 7:12 PM
To: pgsql-general(at)postgresql(dot)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