Re: Upgrading PG - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Upgrading PG
Date
Msg-id 200710011042.25951@hal.medialogik.com
Whole thread Raw
In response to Upgrading PG  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
On Monday 01 October 2007, "Gauthier, Dave" <dave.gauthier@intel.com> wrote:
> I'm going to move from v7.4.13 to v8.2.0 (suse-64). I have 2
> pre-existing DBs.  Do I need to "convert" or port them to v8 in any way
> after I start up with a v8 postmaster?
>

All major version upgrades require a dump and reload. You should read all
the update notes for intermediate versions.

You may also run into some bad-unicode data issues moving from 7.4 to 8.x. I
would do a test run on a separate machine before committing to a conversion
date (always a good idea IMO).

--
Ghawar is dying


pgsql-general by date:

Previous
From: "paul rivers"
Date:
Subject: Re: Partitioned table limitation
Next
From: Gregory Stark
Date:
Subject: Re: more problems with count(*) on large table