Ubuntu – Unable to install software using apt-get in Ubuntu Server

aptaptitudeUbuntu

I'm trying to install some software in my Ubuntu Server 12.04 installation, but whenever I try to install it using apt-get or aptitude, I would usually get an error message like this:

E: unable to locate package postgresql-plperl-9.0
E: couldn't find any package by regex 'postgresql-plperl-9.0'

The contents of my /etc/apt/sources.list file is (all of it are uncommented):

deb http://archive.ubuntu.com/ubuntu precise universe multiverse
deb-src http://archive.ubuntu.com/ubuntu precise universe multiverse

deb http://us.archive.ubuntu.com/ubuntu/ precise universe
deb-src http://us.archive.ubuntu.com/ubuntu/ precise universe
deb http://us.archive.ubuntu.com/ubuntu/ precise-updates universe
deb-src http://us.archive.ubuntu.com/ubuntu/ precise-updates universe

deb http://us.archive.ubuntu.com/ubuntu/ precise multiverse
deb-src http://us.archive.ubuntu.com/ubuntu/ precise multiverse
deb http://us.archive.ubuntu.com/ubuntu/ precise-updates multiverse
deb-src http://us.archive.ubuntu.com/ubuntu/ precise-updates multiverse

deb http://security.ubuntu.com/ubuntu precise-security universe
deb-src http://security.ubuntu.com/ubuntu precise-security universe
deb http://security.ubuntu.com/ubuntu precise-security multiverse
deb-src http://security.ubuntu.com/ubuntu precise-security multiverse

Any help on why I am encountering this issue is greatly appreciated.

Best Answer

If you really need that specific version, you should use the Postgresql APT repos in addition to the Ubuntu repos.

The are located at http://apt.postgresql.org/pub/repos/apt/

The README file has instructions for using it.

Proof, using that old build on a new Ubuntu 14.04 system:

# grep DESC /etc/lsb-release ; apt-cache show postgresql-plperl-9.0
DISTRIB_DESCRIPTION="Ubuntu 14.04.1 LTS"
Package: postgresql-plperl-9.0
Source: postgresql-9.0
Version: 9.0.18-1.pgdg14.04+1
...