Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6733D9F9C35 for ; Tue, 19 Dec 2006 17:40:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 84926-05 for ; Tue, 19 Dec 2006 17:40:38 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 8E9E19F946C for ; Tue, 19 Dec 2006 17:40:37 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id g33so2033900ugd for ; Tue, 19 Dec 2006 13:40:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Rvzxr20wq/+14L/mHUi/kYywARVx+xDFDxQpOATl/DQTbkCgRZcXsNLioa9GVLpnXv1VOGJ0Z8gGaPxwZQ9V4WvahJs6tPxFji1tmSTqkRndCWN6HElIrYLqwQx74hQgVREk/6GaSDLOPsOo4LFjDFv/QBISQF4EMV1xlQFqzI8= Received: by 10.82.111.8 with SMTP id j8mr1270218buc.1166564436143; Tue, 19 Dec 2006 13:40:36 -0800 (PST) Received: by 10.82.112.5 with HTTP; Tue, 19 Dec 2006 13:40:36 -0800 (PST) Message-ID: <1d219a6f0612191340w4f7c2e35q2c15044d3017a01d@mail.gmail.com> Date: Tue, 19 Dec 2006 16:40:36 -0500 From: "Chris Hoover" To: "=?ISO-8859-1?Q?Rickard_Sj=F6str=F6m?=" Subject: Re: Upgrading from 7.4 to 8.2 Cc: "Rajesh Kumar Mallah" , "Matthias.Pitzl@izb.de" , pgsql-admin@postgresql.org In-Reply-To: <200612191659.kBJGxXeK029916@mi1.bluebottle.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10346_10341806.1166564436105" References: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61> <200612191659.kBJGxXeK029916@mi1.bluebottle.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/273 X-Sequence-Number: 24065 ------=_Part_10346_10341806.1166564436105 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Very easy, Install the new version of PostgreSQL on your new machine. Then use the ne= w machine's install to pg_dump the old machine's database and load it into th= e 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=F6str=F6m 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 DATADI= R > to the new machine and then start the postgresql server there with the ol= d > DATADIR should work without problems? > > Thanks, again! > > /Rickard > > Citerar Rajesh Kumar Mallah : > > > 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.Pitzl@izb.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@postgresql.org > > > > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of > > > > Rickard Sj=F6str=F6m > > > > Sent: Tuesday, December 19, 2006 10:04 AM > > > > To: pgsql-admin@postgresql.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@postgresql.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@postgresql.org so that your > message can get through to the mailing list cleanly > ------=_Part_10346_10341806.1166564436105 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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&#= 39;s database and load it into the new machine (obviously, the machines mus= t be table to talk to each other over the network).  Very easy.  = That is how I upgraded all of my servers from=20 7.3.4 to 8.1.3. (An upgrade that went very smoothly with no hiccups.)
HTH,

Chris

On 12/19/06, Rickard Sj=F6str=F6m < rickard.sjostrom@bluebottle.com> wrote:
Hi!
Thanks for your replies!

My problem is that I want to move the DBM to a different machine so now whe= n 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= =20 7.4 I guess the procedure to move the DATADIR to the new machine and then s= tart the postgresql server there with the old DATADIR should work without p= roblems?

Thanks, again!

/Rickard

Citerar Rajesh Kumar = Mallah < mallah.rajesh@gmail.com>:=

> Dear Rickard,
>
> The jump from 7.4 to 8.2 is rath= er big.
> I would suggest doing just a dry run by  dumping<= br>> the database schema without data and restoring it
> into 8.2 database . this can be time saving in detecting
> p= ossible problems in migration.
>
> in case there is some non tr= ivial problem
> you may take intermediate path of upgrading
>= =20 7.4-->8.0.x-->8.1.x -->8.2.0
> where x denotes the last mino= r release of a major
> release.
>
> regds
> mallah.=
>
>
> On 12/19/06, Matthias.Pitzl@izb.de <Matt= hias.Pitzl@izb.de> wrote:
> > Hi Rickard!
> >
&= gt; > As far as i know you will have to dump and restore the databases
> for the
> > upgrade since a lot of internals have been ch= anged 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!
> >
> > Greetin= gs,
> > Matthias
> >
> > > -----Original Mess= age-----
> > > From: pgsql-admin-owner@postgresql.org
> > > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of
> > > Rickard Sj=F6str=F6m
> > > Se= nt: Tuesday, December 19, 2006 10:04 AM
> > > To:
pgsql-= admin@postgresql.org
> > > Subject: [ADMIN] Upgrading from = 7.4 to 8.2
> > >
> > >
> > > Hi!
>= ; > > I have PostgreSQL=20 7.4 DBM and want to upgrade to 8.2 (latest
> > > in version 8 I= quess).
> > >
> > > Can use the DATADIR from 7.4 a= nd just upgrade the
> > > DBM/postgresql server to 8.2?
> > >
> > > Is the upgrade from 7 to 8 procedure writt= en down somewhere?
> > > (could not find anyting at
> >= ; > http://www.pos= tgresql.org/docs/techdocs.2 , > except from 6 to
> > > 7)
> > >
> = > > I guess I could dump all my data and restore it later but it
&= gt; > > would be much nicer if it was possible to just start a new
> > > PostgreSQL server with the old DATADIR repository!
&g= t; > >
> > > Thanks!
> > >
> > > = /Rick
> > >
> > >
> -------------------------= ---------------------------------------------
> > > Diamond Ring Auctions at Bidz!
> > > Engagem= ent 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
> > >
> >
> > ---------------------------(en= d of
> broadcast)---------------------------
> > TIP 1: if p= osting/reading through Usenet, please send an
> appropriate
> &= gt;       subscribe-nomail command to=20 majordomo@postgresql.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/B= gLEQfI7q8COE6YTwzNhNIsdKPTGDJaJS3gO/


---------------------------(end of broadcast)--------------= -------------
TIP 1: if posting/reading through Usenet, please send an a= ppropriate
       subscribe-nomail command= to majordomo@postgresql.org so that your
     =   message can get through to the mailing list cleanly
=

------=_Part_10346_10341806.1166564436105--