Re: Upgrading PostgreSQL 7.1.3

Date: Sun, 24 Aug 2003 23:25:24 +0200
^^^^
The date's wrong on your computer.

"ruben20(at)superguai(dot)com" <ruben20(at)superguai(dot)com> wrote:
> Hi:
>
> I'm planning to migrate a postgres database version 7.1.3 to a newer
> version. There are some tables with up to 5 million records and I'm
> begining to suffer from data corruption in indexes and tables. I did
> some hardware checkings and everything seems ok. The last move, as
> someone suggested in this list would be to upgrade postgres version.
>
> What is the most advisable version I should upgrade to? My top goal is
> reliability. Do I have to install/reinstall or upgrade? Do I need to be
> concerned of any special feature when dumping/restoring data? Is there
> any good doc about this?

Make absolutely sure you have a good dump of your data. You would do
well to upgrade to the latest 7.4.5. Be prepared to spend some time on
it, as the jump from 7.1 to 7.4 is a long way.

I don't know what specific problems you might encounter, but be prepared.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com