Installing Django with PostgreSQL on Ubuntu
Antonio Cangiano December 26th, 2007
This how-to is essentially the same as my previous one, only this time I’ve provided step-by-step instructions for installing Django with PostgreSQL on Ubuntu 7.10.
First and foremost, we are going to install Django from its svn repository, as opposed to obtaining the 0.96 release archive. The reason for this is that the trunk version implements a few new features. The development code is also rather stable and used by most people in production mode, even for sites like the Washington Post.
Install Subversion
sudo apt-get install subversion
Checkout Django
svn co http://code.djangoproject.com/svn/django/trunk django_trunk
Tell Python where Django is
Ubuntu already ships with Python 2.5.1, thus you won’t have to install it. You can verify this by running python in your shell (use exit() to get out of the python shell). What you need to do is inform Python about the location of your django_trunk directory. To do this create the following file:
/usr/lib/python2.5/site-packages/django.pth
Within this file, place only one line containing the path to your django_trunk folder. In my case, this is:
/home/antonio/django_trunk
Of course, change it to the full path location of the directory on your filesystem.
Add django-admin.py to your PATH
The bin directory within the django folder (which is inside django_trunk itself) contains several management utilities. We need therefore to add the following to the PATH (again, change it to your own location):
/home/antonio/django_trunk/django/bin
How you go about doing this, depends on the shell you are using, and I’m assuming you are able to export a shell variable on your own. In case you are using the bash shell (as I do) you could export it in .bashrc. Alternatively, you could just create a symlink to the utility django-admin.py in /usr/bin, but I recommend the former approach.
Install PostgreSQL and Psycopg2
sudo apt-get install postgresql pgadmin3 python-psycopg2
This will install PostgreSQL 8.2.5, PgAdmin III and the driver Psycopg2 for you. Most people at this point will ask, what’s the default password for PostgreSQL on Ubuntu? You can use the following instructions to set the password for the user postgres both in Ubuntu and within PostgreSQL:
sudo su -
passwd postgres
su postgres
psql template1
The last instruction should open the psql shell, where you can run the following:
ALTER USER postgres WITH ENCRYPTED PASSWORD ‘mypassword’;
Verify the installation
You should be all set now, but let’s verify this right away. Open the shell and run the following instructions inside the python shell (start off with the python command).
>>> import django
>>> print django.VERSION
(0, 97, ‘pre’)
>>> import psycopg2
>>> psycopg2.apilevel
‘2.0′
By running exit() get out of the python shell, and verify that django-admin.py is in your path:
django-admin.py
Type ‘django-admin.py help’ for usage.
If you obtain a similar output for all three of them, you are really set.
Where to go from here
Now that Django is installed, you can go read the Django Book 1.0 that’s available for free online. Something equally well done and useful is really missing from the Rails community. Above all, experiment, Django (and programming in general) is learnt by doing. The Definitive Guide to Django: Web Development Done Right
and even a 
. The problem is that unless your site is popular, you won’t be of any interest to advertisement agencies who work on behalf of big companies. They are looking for millions of impressions and chances are that your programming blog won’t ever reach anything remotely close to that. So you are stuck with ridiculously low eCPMs from Google, which serves thousands upon thousands of impressions for less than a breakfast at Starbucks.
