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@xxxxxxxxxxxxxxx> wrote:
On Mon, Aug 1, 2011 at 9:12 AM, Atul Goel <Atul.Goel@xxxxxxxxxxx> wrote:consider that 9.0 is not the next version after 8.0, there were 4 more
> 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
they are all mentioned in realese notes... look the "Migration to
> 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).
>
Version X.X" in the release notes for the above mentioned versions
probably but i'm not so sure about it
> 2) Do I need to upgrade JDBC driver when I upgrade to postgres9.0.
>
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
---
John L Cheng
