Re: migrate data 6.5.3 -> 8.3.1 - Mailing list pgsql-hackers

From Kenneth Marshall
Subject Re: migrate data 6.5.3 -> 8.3.1
Date
Msg-id 20080814145116.GA4402@it.is.rice.edu
Whole thread Raw
In response to Re: migrate data 6.5.3 -> 8.3.1  ("David Blewett" <david@dawninglight.net>)
Responses Re: migrate data 6.5.3 -> 8.3.1  (alexander lunyov <lan@zato.ru>)
List pgsql-hackers
When upgrading, you use the pg_dump from the new version to
dump the old database. Then it can take care of incidental
changes during the process. I think that the mailing list
archives have articles on upgrading from v6.5. I do not think
that you can go straight from v6.5 to v8.3. You will almost
certainly need to use v7.2-7.4 as a intermediate step, maybe
v8.0 will work, check the list archives. Good luck.

Cheers,
Ken

On Thu, Aug 14, 2008 at 10:34:11AM -0400, David Blewett wrote:
> On Thu, Aug 14, 2008 at 9:58 AM, alexander lunyov <lan@zato.ru> wrote:
> > Hello everybody.
> >
> > We have a dusty old server, FreeBSD 3.3-RELEASE, PostgreSQL 6.5.3.
> > I need to migrate four DBs from old server to new server (FreeBSD 6.2,
> > PostgreSQL 8.3.1).
> 
> Just an FYI: I advised Alexander to post here, because I thought some
> of the devs might have older pg installs/dump tools and might be able
> to give some advice.
> 
> David Blewett
> 
> -- 
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
> 


pgsql-hackers by date:

Previous
From: "David Blewett"
Date:
Subject: Re: migrate data 6.5.3 -> 8.3.1
Next
From: Zdenek Kotala
Date:
Subject: Re: Patch: propose to include 3 new functions into intarray and intagg