Re: Postgres 8.0 upgrade to 9.0

Hi Atul,

On 1.8.2011 16:12, Atul Goel wrote:
> We are planning to upgrade a postgres 8.0 database to postgres 9.0
> (Actually already done in Dev). The application is J2EE application with
> Hibernate. My question are
>
> 1)Is there a list of things that needs to be taken care while
> upgrading(known issues).

In past two years, we migrated JavaEE and Java Spring applications from
Postgres 8.1 -> 8.3 -> 8.4 -> 9.0, only bigger issue was, as Scott
already mentioned, removal of explicit casts.

Please read:

   http://www.postgresql.org/docs/8.3/static/release-8-3.html,
especially section E.16.2.1.

Also note, that postgresql.conf parameters are sligtly changed, so you
shoud also pay attention there. For instance, max_fsm_pages is obsolete
since 8.4.


> 2)Do I need to upgrade JDBC driver when I upgrade to postgres9.0.

Absolutely. Using older driver on new Postgres DB could bring you
unexpected results (e.g. we got corrupted metadata, bytea colums were
encoded badly, and so on).


-Ognjen