Re: Considering an upgrade... - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Considering an upgrade...
Date
Msg-id 1129057173.29961.109.camel@state.g2switchworks.com
Whole thread Raw
In response to Considering an upgrade...  (Gary Horton <Gary.Horton@Sun.COM>)
Responses Re: Considering an upgrade...  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
On Tue, 2005-10-11 at 10:50, Gary Horton wrote:
> I'm needing to convince my boss that we should upgrade from 7.3.4 to
> 8.x Postgresql. I've already enumerated the upsides, but now we need
> to consider the risks...I wonder if anyone can mention/summarize any
> issues, problems, gotchas, etc. that have happened in anyone's upgrade
> from 7.x to 8.x ... this would be greatly appreciated. For that
> matter, if there are any benefits people have seen in addition to
> what's mentioned on postgres website, this would be good info too.
>
> We are on a Solaris system (including customers with sol 8, 9, and
> 10), running 7.3.4.  Thanks in advance ... and if you would, please cc
> me at my email address since I'm not subscribed to this alias.

If you'd like to see if all your data works in 8.0 AND that all your
updates / inserts / deletes work there too, you can use the trick of
making a slony replicant running 8.0 under your 7.3 server and seeing if
everything runs smoothly on the 8.0 server before trying it under the
real app.  This will let you make sure it works in production before
committing to an update.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: fine tuned database dump/reload?
Next
From: "Florian G. Pflug"
Date:
Subject: Re: Considering an upgrade...