Re: Upgrading from 7.2.3 to....?? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Upgrading from 7.2.3 to....??
Date
Msg-id 20031201003317.GA27024@wolff.to
Whole thread Raw
In response to Upgrading from 7.2.3 to....??  (Carlos Moreno <moreno@mochima.com>)
List pgsql-general
On Sun, Nov 30, 2003 at 14:56:26 -0500,
  Carlos Moreno <moreno@mochima.com> wrote:
>
> Since our upgrade will most likely take place early in
> January, maybe by then we'll have a better idea about
> how 7.4 performs in the real world, concerning stability/
> reliability?
>
> What would be your advice?  Is 7.3.4 the recommended one
> if we need reliability?  Or has 7.4 earned sufficient
> trust by now?

You should go right to some version of 7.4. 7.4.1 should be out soon.
7.4 has a number of performance and maintainability features that you
don't want to miss. Going to 7.3 will be ablut as hard as going to 7.4,
so you might as well get the extra benefit.

> Also, how about back compatibility?  Should I expect some
> trouble?  I remember with one of the previous upgrades
> (I think it was from 7.1.* to 7.2.*), one of our SQL
> statements stopped working, and it did it pretty silently
> (i.e., the effect of the error would only be noticed under
> certain conditions).  After a while, we noticed the error,
> and it was trivial to fix, but now it worries me now
> whenever I have to upgrade to a new second-digit in the
> version.

Schemas are new in 7.3 and that might cause you to worry about them.
You can read through the release notes for 7.3 and 7.4 to look for
changes that might cause you problems.

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: Was: Triggers, Stored Procedures, PHP
Next
From: David Nedrow
Date:
Subject: Re: pg_hba.conf problem