Re: Postgres 8.0 upgrade to 9.0

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(at)2ndquadrant(dot)com>wrote:

> On Mon, Aug 1, 2011 at 9:12 AM, Atul Goel <Atul(dot)Goel(at)iggroup(dot)com> wrote:
> > Hi Forum,
> >
> > We are planning to upgrade a postgres 8.0 database to postgres 9.0
> (Actually
> > already done in Dev).
>
> consider that 9.0 is not the next version after 8.0, there were 4 more
> (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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
---
John L Cheng