Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BB9DD9F946C for ; Tue, 19 Dec 2006 17:44:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 33467-04 for ; Tue, 19 Dec 2006 17:44:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id B7C2D9FA0EF for ; Tue, 19 Dec 2006 17:44:09 -0400 (AST) Received: from [192.168.1.50] (or-67-76-146-141.sta.embarqhsd.net [67.76.146.141]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id kBJLhqag023502 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Tue, 19 Dec 2006 13:43:53 -0800 Subject: Re: Upgrading from 7.4 to 8.2 From: "Joshua D. Drake" To: Chris Hoover Cc: Rickard =?ISO-8859-1?Q?Sj=F6str=F6m?= , Rajesh Kumar Mallah , "Matthias.Pitzl@izb.de" , pgsql-admin@postgresql.org In-Reply-To: <1d219a6f0612191340w4f7c2e35q2c15044d3017a01d@mail.gmail.com> References: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61> <200612191659.kBJGxXeK029916@mi1.bluebottle.com> <1d219a6f0612191340w4f7c2e35q2c15044d3017a01d@mail.gmail.com> Content-Type: text/plain; charset=utf-8 Organization: Command Prompt, Inc. Date: Tue, 19 Dec 2006 13:45:59 -0800 Message-Id: <1166564759.22487.142.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: ClamAV version 0.88.5, clamav-milter version 0.88.5 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Tue, 19 Dec 2006 13:43:53 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/275 X-Sequence-Number: 24067 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 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.rajesh@gmail.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.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öström > > > > 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 > -- === 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