Install postgres 9.0 in debian lenny [closed]

Question

Dear all,
My system has the following distribution details

$ lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 5.0 (lenny)
Release:    5.0
Codename:   lenny

I need to install postgres 9.0 in this machine , but I cannot find any stable lenny packages for postgres 9.0 , Is there any other way to do this
Any suggestion would be appreciated !

Answer 1

Thanks to the new debian backports suite, here's how to install PostgreSQL 9.0 on Debian lenny:

Add the following to /etc/apt/sources.list:

deb http://backports.debian.org/debian-backports lenny-backports   main
deb http://backports.debian.org/debian-backports lenny-backports-sloppy main

Then run these 2 commands

apt-get install -t lenny-backports postgresql-common
apt-get install -t lenny-backports-sloppy postgresql-9.0 postgresql-client-9.0 postgresql-contrib-9.0

Note that this utilizes the new lenny-backports-sloppy backport suite - please read the announcement in order to be aware of the trade offs of using this suite.

Answer 2

Installing from source is quite easy:

   Basically: Download postgresql-9.0.1.tar.bz2

    tar xjf postgresql-9.0.1.tar.bz2
    cd postgresql-9.0.1
    ./configure
    make 
    make install

Details here

Answer 3

thanks leonbloy the backport for lenny is no longer supported. use this site to download

http://ftp.riken.go.jp/pub/FreeBSD/distfiles/postgresql/

wget http://ftp.riken.go.jp/pub/FreeBSD/distfiles/postgresql/postgresql-version.tar.bz2

Then follow leonbloy's instructions above and read the file INSTALL when you uncompress the file.