Message-ID: <47D77929.7030401@postnewspapers.com.au>
Date: Wed, 12 Mar 2008 15:33:13 +0900
From: Craig Ringer <craig@postnewspapers.com.au>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: sathiya psql <sathiya.psql@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: migration of 7.4 to 8.1
References: <f966c2ee0803112227y7c969d52pea8e228ed0fbbdf3@mail.gmail.com>	
	<47D76AFA.7020100@postnewspapers.com.au>
	<f966c2ee0803112324m7c863501kd6e33bc5b44ca010@mail.gmail.com>
In-Reply-To: <f966c2ee0803112324m7c863501kd6e33bc5b44ca010@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.

--
Craig Ringer