I am planning on bringing our 8.3 installation up to 9.0.4. First I upgraded the jdbc driver on our staging environment, after 1 month on staging, we tested with the 9.0 driver on production. The actual database upgrade will be more complicated, and we are going to simulate an upgrade on a non-production environment first to help anticipate problems.
Going from 8.0 to 9.0 could be a lot more complicated. But I'd recommend planning to upgrade pieces incrementally and of course always test before pushing to production.
On Mon, Aug 1, 2011 at 9:03 AM, Jaime Casanova
<jaime@2ndquadrant.com> wrote:
On Mon, Aug 1, 2011 at 9:12 AM, Atul Goel <
Atul.Goel@iggroup.com> wrote:
> Hi Forum,
>
> We are planning to upgrade a postgres 8.0 database to postgres 9.0 (Actually
> already done in Dev).
(8.1, 8.2, 8.3 and 8.4) and at least for changing from 8.2 to 8.3 you
probably will need to fix your app
> 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).
>
they are all mentioned in realese notes... look the "Migration to
Version X.X" in the release notes for the above mentioned versions
> 2) Do I need to upgrade JDBC driver when I upgrade to postgres9.0.
>
probably but i'm not so sure about it
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
---
John L Cheng