Re: migration of 7.4 to 8.1

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