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.