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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
