PostgreSQL 9.0 or 9.1 ?

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PostgreSQL 9.0 or 9.1 ?
Date: 2011-06-16 14:06:31
Message-ID: 201106161706.31758.achill@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello again! (i got my traditional email-address back!)
we have been running our infrastructure on 8.3 for quite some years now,
and i am thinking it is now time to upgrade all major parts of our system
(java, jboss, postgresql).

I would tend to be a little "radical" and go a little optimistic and greedy about it.
I have been using 9.0 as a test system with no major flaws for quite some time as well.
(but unfortunately without exploiting any of its new features)

Till the end of July i must have finished all the migration to the new versions.

The migration will involve testing of about 5,458 sql statements and the
migration of some heavily customized in house functions, including
a version of DBmirror (which is in use for a very specific set of problems)

So i am asking what would be better from your perspective to do?
Go for 9.1? or stick to 9.0 and try to deploy it and take the most out of it?

When is a stable (release) version of 9.1 be available?

Has any one faced any issues migrating from 9.0 to 9.1

--
Achilleas Mantzios

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2011-06-16 14:16:18 Re: Constraint to ensure value does NOT exist in another table?
Previous Message Tom Lane 2011-06-16 13:58:08 Re: order by and view def.