Re: Upgrading from 7.4 to 8.2

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Chris Hoover <revoohc(at)gmail(dot)com>
Cc: Rickard Sjöström <rickard(dot)sjostrom(at)bluebottle(dot)com>, 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:45:59
Message-ID: 1166564759.22487.142.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 2006-12-19 at 16:40 -0500, Chris Hoover wrote:
> 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.)

Except that there are behavioral differences between 8.1.3 and 7.4
including how floats respond to '' input. I believe there are also
library version bumps which will likely effect him if he does not
recompile his apps because he might remove 7.4 after getting a
successful upgrade of his data just to find that PHP or Perl doesn't
work anymore.

Joshua D. Drake

>
> 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.2 I 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
>
--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Achilleas Mantzios 2006-12-20 07:56:44 Re: DBmirror
Previous Message Chris Hoover 2006-12-19 21:44:06 Re: Suggestions needed about how to dump/restore a database