Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8B7632E2EDC for ; Wed, 12 Mar 2008 03:50:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 88515-03 for ; Wed, 12 Mar 2008 03:50:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from bifrost.lang.hm (mail.lang.hm [64.81.33.126]) by postgresql.org (Postfix) with ESMTP id 64A122E2ED9 for ; Wed, 12 Mar 2008 03:50:23 -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 m2C6bGMO026914; Tue, 11 Mar 2008 22:37:16 -0800 Date: Tue, 11 Mar 2008 23:39:40 -0700 (PDT) From: david@lang.hm X-X-Sender: dlang@asgard.lang.hm To: Craig Ringer cc: sathiya psql , pgsql-performance@postgresql.org Subject: Re: migration of 7.4 to 8.1 In-Reply-To: <47D77929.7030401@postnewspapers.com.au> 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; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/250 X-Sequence-Number: 29204 On Wed, 12 Mar 2008, Craig Ringer wrote: > sathiya psql wrote: >>> This might be a silly question, but ... why 8.1 ? >>> >>> If you're doing a major upgrade, why not go straight to 8.3? It's been >>> out long enough that there aren't any obvious nasty bugs, and there have >>> been a fair few fixes and improvements since prior versions. >>> >> Because am using Debian ETCH stable... i need to continue using this... In >> Debian ETCH stable 8.1 is only there.... > > I use Etch on my servers. The magic of etch-backports from backports.org > allows me to use 8.3 without messing with anything else. It works extremely > well. > > All I had to do to install 8.3 was add the etch-backports line to my > /etc/apt/sources.list, run `apt-get update', then run: > > apt-get -t etch-backports install postgresql-8.3 > > ... then migrate the data to it and remove the old packages. > > See backports.org for a mirror list. > >> I will be installing my project in other machines where it is having DEBIAN >> ETCH STABLE, i dont want to face any problems... so only... >> >> am i right ??? > > Personally I'd use 8.3 from backports.org, but it's of course up to you. consider the fact that after 1 year Etch is 2 major releases out of date. by the time the next stable release is made you will be running on ancient versions unless you make use of backports.org (or compile it yourself, which is useually my choice). David Lang