Skip site navigation (1) Skip section navigation (2)

Re: migration of 7.4 to 8.1

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org, "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>
Subject: Re: migration of 7.4 to 8.1
Date: 2008-03-13 05:50:21
Message-ID: dcc563d10803122250t2901efe2o600ac6b19cdcfcd3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, Mar 12, 2008 at 8:17 PM, Robert Treat
<xzilla(at)users(dot)sourceforge(dot)net> wrote:
> On Wednesday 12 March 2008 01:27, sathiya psql wrote:
>  > Is there any article describing the migration database from postgresql
>  > 7.4to 8.1
>
>  I don't know of any specific references, but the process is not fundementally
>  different from any other major version upgrade. You'll want to do a schema
>  only dump of your current database any load that into the 8.1 database. Once
>  you feel comfortable that this works ok, try a data only dump and load that
>  into the 8.1 server.  Once you comfortable all that works, you're ready to
>  upgrade.
>
>  I will note that if you're planning to upgrade, I'd recommend going stright to
>  8.3.  8.1 is a few years old, and 8.3 provides a number of features and
>  improvement you'll benefit from. Unless you have a strong reason to do
>  otherwise, go to 8.3. HTH.

And if the OP is worried about running too new a version of pgsql,
8.2.6 is very mature.  But if he's got 6 or more months until he goes
live, which is common, I'd recommend going to 8.3 which will be well
polished by then.

In response to

Responses

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2008-03-13 05:56:40
Subject: Re: migration of 7.4 to 8.1
Previous:From: Robert TreatDate: 2008-03-13 03:28:42
Subject: Re: Encoding problems with migration from 8.0.14 to 8.3.0 on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group