I build websites.
Notes on installing PostgreSQL on Debian 6.0 "Squeeze."
My Debain package management skills have gotten rusty. These are mostly notes to myself about installing PostegreSQL 9.1 to a fresh Debain 6.0 install.
Add the following line to
# backports for postgres 9.1 deb http://backports.debian.org/debian-backports squeeze-backports main contrib non-free
sudo apt-get update to pull down the new backports. Finally run
apt-get -t squeeze-backports install postgresql-9.1 in order to install from the backport source. All the hstore and bonus features of postgres can be installed with
apt-get -t squeeze-backports install postgresql-contrib-9.1.
-t squeeze-backports flag I kept getting the following error.
The following packages have unmet dependencies: postgresql-9.1 : Depends: libpq5 (>= 9.1~beta1) but 8.4.9-0squeeze1 is to be installed Depends: postgresql-client-9.1 but it is not going to be installed Depends: postgresql-common (>= 115~) but 113 is to be installed E: Broken packages
In order to install the Ruby pg gem you'll need the following package:
apt-get -t squeeze-backports install libpq-dev
Hope this saves someone else a few minutes.
Summary: using apt-get to install PostgreSQL 9.1 on Debain 6 (Squeeze)