Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0AB122E2F70 for ; Wed, 12 Mar 2008 03:48:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 87359-01-2 for ; Wed, 12 Mar 2008 03:48:06 -0300 (ADT) X-Greylist: delayed 00:10:48.808015 by SQLgrey-1.7.5 Received: from bifrost.lang.hm (mail.lang.hm [64.81.33.126]) by postgresql.org (Postfix) with ESMTP id 9EA042E3099 for ; Wed, 12 Mar 2008 03:48:08 -0300 (ADT) Received: from asgard.lang.hm (asgard.lang.hm [10.0.0.100]) by bifrost.lang.hm (8.13.4/8.13.4/Debian-3) with ESMTP id m2C6m55J026955; Tue, 11 Mar 2008 22:48:05 -0800 Date: Tue, 11 Mar 2008 23:50:30 -0700 (PDT) From: david@lang.hm X-X-Sender: dlang@asgard.lang.hm To: sathiya psql cc: Craig Ringer , pgsql-performance@postgresql.org Subject: Re: migration of 7.4 to 8.1 In-Reply-To: Message-ID: References: <47D76AFA.7020100@postnewspapers.com.au> <47D77929.7030401@postnewspapers.com.au> User-Agent: Alpine 1.00 (DEB 882 2007-12-20) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/248 X-Sequence-Number: 29202 On Wed, 12 Mar 2008, sathiya psql wrote: > My question is that how to migrate my database to 7.4 to 8.1 > > > that is not only dumping the db and extracting that in 8.1 .. > > If i do that whether it will work without problem, or i have to do some > manual changes is my question... you would need to look at the release notes for each version to see if you are using any of the features that were changed. but in return for this hassle (which you will need to do eventually, you are just deciding when) you get to use the newer version with all the speed improvements, not to mention the new features. going from 7.x to 8.0 is the most painful step. going on from 8.0 to 8.1 to 8.2 to 8.3 are relativly minor steps in comparison. David Lang