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

Re: Upgrading from 7.4 to 8.2

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: Rickard Sjöström <rickard(dot)sjostrom(at)bluebottle(dot)com>
Cc: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>, "Matthias(dot)Pitzl(at)izb(dot)de" <Matthias(dot)Pitzl(at)izb(dot)de>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Upgrading from 7.4 to 8.2
Date: 2006-12-19 21:40:36
Message-ID: 1d219a6f0612191340w4f7c2e35q2c15044d3017a01d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Very easy,

Install the new version of PostgreSQL on your new machine.  Then use the new
machine's install to pg_dump the old machine's database and load it into the
new machine (obviously, the machines must be table to talk to each other
over the network).  Very easy.  That is how I upgraded all of my servers
from 7.3.4 to 8.1.3. (An upgrade that went very smoothly with no hiccups.)

HTH,

Chris

On 12/19/06, Rickard Sjöström <rickard(dot)sjostrom(at)bluebottle(dot)com> wrote:
>
> Hi!
> Thanks for your replies!
>
> My problem is that I want to move the DBM to a different machine so now
> when it doesn't seem to be any easy/trivial way to migrate from 7.4 to 8.2I might consider to continue with
> 7.4.
>
> If I decide to continue with 7.4 I guess the procedure to move the DATADIR
> to the new machine and then start the postgresql server there with the old
> DATADIR should work without problems?
>
> Thanks, again!
>
> /Rickard
>
> Citerar Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>:
>
> > Dear Rickard,
> >
> > The jump from 7.4 to 8.2 is rather big.
> > I would suggest doing just a dry run by  dumping
> > the database schema without data and restoring it
> > into 8.2 database . this can be time saving in detecting
> > possible problems in migration.
> >
> > in case there is some non trivial problem
> > you may take intermediate path of upgrading
> > 7.4-->8.0.x-->8.1.x -->8.2.0
> > where x denotes the last minor release of a major
> > release.
> >
> > regds
> > mallah.
> >
> >
> > On 12/19/06, Matthias(dot)Pitzl(at)izb(dot)de <Matthias(dot)Pitzl(at)izb(dot)de> wrote:
> > > Hi Rickard!
> > >
> > > As far as i know you will have to dump and restore the databases
> > for the
> > > upgrade since a lot of internals have been changed from 7.4 to
> > 8.2.
> > > A description on how to upgrade can be found here:
> > >
> > http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html
> > > And here:
> > http://www.postgresql.org/docs/8.2/interactive/migration.html
> > >
> > > Good luck!
> > >
> > > Greetings,
> > > Matthias
> > >
> > > > -----Original Message-----
> > > > From: pgsql-admin-owner(at)postgresql(dot)org
> > > > [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of
> > > > Rickard Sjöström
> > > > Sent: Tuesday, December 19, 2006 10:04 AM
> > > > To: pgsql-admin(at)postgresql(dot)org
> > > > Subject: [ADMIN] Upgrading from 7.4 to 8.2
> > > >
> > > >
> > > > Hi!
> > > > I have PostgreSQL 7.4 DBM and want to upgrade to 8.2 (latest
> > > > in version 8 I quess).
> > > >
> > > > Can use the DATADIR from 7.4 and just upgrade the
> > > > DBM/postgresql server to 8.2?
> > > >
> > > > Is the upgrade from 7 to 8 procedure written down somewhere?
> > > > (could not find anyting at
> > > > http://www.postgresql.org/docs/techdocs.2, > except from 6 to
> > > > 7)
> > > >
> > > > I guess I could dump all my data and restore it later but it
> > > > would be much nicer if it was possible to just start a new
> > > > PostgreSQL server with the old DATADIR repository!
> > > >
> > > > Thanks!
> > > >
> > > > /Rick
> > > >
> > > >
> > ----------------------------------------------------------------------
> > > > Diamond Ring Auctions at Bidz!
> > > > Engagement rings auctioned daily. Every 5 seconds, starting at
> > $1!
> > > >
> > http://tags.bluebottle.com/fc/BgLEQfJCfpRhST38x1THooDD28i6CkYTg1zn/
> > > >
> > > >
> > > > ---------------------------(end of
> > > > broadcast)---------------------------
> > > > TIP 5: don't forget to increase your free space map settings
> > > >
> > >
> > > ---------------------------(end of
> > broadcast)---------------------------
> > > TIP 1: if posting/reading through Usenet, please send an
> > appropriate
> > >       subscribe-nomail command to majordomo(at)postgresql(dot)org so
> > that your
> > >       message can get through to the mailing list cleanly
> > >
> >
>
> ----------------------------------------------------------------------
> Free Debt Consolidation Quote
> FCCC offers free counseling & debt consolidation quote. No setup fee!
> http://tags.bluebottle.com/fc/BgLEQfI7q8COE6YTwzNhNIsdKPTGDJaJS3gO/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly
>

In response to

Responses

pgsql-admin by date

Next:From: Chris HooverDate: 2006-12-19 21:44:06
Subject: Re: Suggestions needed about how to dump/restore a database
Previous:From: Tom KalafutDate: 2006-12-19 19:48:48
Subject: Re: multiple postgres instances from RPM install

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