Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5DF209F9386 for ; Tue, 19 Dec 2006 13:00:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 84107-02 for ; Tue, 19 Dec 2006 12:59:31 -0400 (AST) X-Greylist: delayed 07:55:37.597614 by SQLgrey-1.7.4 Received: from mi1.bluebottle.com (mi1.bluebottle.com [206.188.25.14]) by postgresql.org (Postfix) with ESMTP id A1BF59FA2D4 for ; Tue, 19 Dec 2006 12:59:37 -0400 (AST) Received: from localhost.localdomain (localhost.localdomain [127.0.0.1]) by mi1.bluebottle.com (8.13.1/8.13.1) with ESMTP id kBJGxXeK029916 for ; Tue, 19 Dec 2006 08:59:34 -0800 DomainKey-Signature: a=rsa-sha1; s=mail; d=bluebottle.com; c=simple; q=dns; h=received:to:cc:date:from:subject:references:in-reply-to: mime-version:content-type:content-transfer-encoding:user-agent; b=ptPdHvtzjtoAIpWBhTWUEvQL5kex6YLZ5RPXEZR4GqwYtZwxNrc8Qu0tkSX6X3g0f 4lhE2HL/+yZXlCxZUbI+QKAH8ZO66r2A0qanQCNo+QYJfOGIoYAdfyFJmwc7WW1 Message-Id: <200612191659.kBJGxXeK029916@mi1.bluebottle.com> Received: from localhost (internal.bluebottle.com [206.188.24.43]) (authenticated bits=0) by fe1.bluebottle.com (8.13.1/8.13.1) with ESMTP id kBJGxR7C009935; Tue, 19 Dec 2006 08:59:30 -0800 Received: from hjv014a.boklok-tomtebo2.se (hjv014a.boklok-tomtebo2.se [81.26.231.167]) by mail.bluebottle.com (IMP) with HTTP for ; Tue, 19 Dec 2006 08:59:26 -0800 To: Rajesh Kumar Mallah Cc: "Matthias.Pitzl@izb.de" , rickard.sjostrom@bluebottle.com, pgsql-admin@postgresql.org Date: Tue, 19 Dec 2006 08:59:26 -0800 From: Rickard =?iso-8859-1?b?U2r2c3Ry9m0=?= Subject: Re: Upgrading from 7.4 to 8.2 References: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.2 X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on localhost X-Virus-Status: Clean X-Trusted-Delivery: <4bdfcca80c142184c61c20d5a10912ab> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/261 X-Sequence-Number: 24053 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 : > 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/